Column Actions

A method to conditionally add CSS styles to cells in an Interactive or Classic report, based on cell data (or any other source you can put in the query, really).
Original info: https://stackoverflow.com/questions/79245897/conditionally-formatting-background-color-for-interactive-report-cells-of-type-l

For a way to do this in Interactive Grids, take a look at The APEX IG Cookbook by John Snyders.
The "Cell Style Based on Data" page in there contains all the info you need.

---

Region

Identification
	Sequence	20
	Title	Interactive Report
	Type	Interactive Report
Source
	Location	Local Database
	Query Type	SQL Query
	Region Source	select emp.empno , emp.ename , emp.job , ( case emp.job when 'MANAGER' then 'ir-data-style="background-color: LightGreen;"' else null end ) as job_css from emp
Appearance
	Template	Standard

Report Column

Identification
	Column Name	JOB
	Type	ESCAPE_SC (Escape special characters)
Heading
	Heading	Job
Column Formatting
	HTML Expression	<span #JOB_CSS#>#JOB#</span>
Security
	Escape Special Characters	Yes

Report Column

Identification
	Column Name	JOB_CSS
	Type	HIDDEN
Heading
	Heading	Job Css
Security
	Escape Special Characters	No

Dynamic Action

Identification
	Name	IR After Refresh - Set data-style
Execution Options
	Sequence	30
When
	Event	After Refresh
	Selection Type	Region
	Region	Interactive Report
Advanced
	Event Scope	Static
True Action
Identification
	Action	Execute JavaScript Code
Settings
	Code	apex.jQuery("span[ir-data-style]").each( function() { apex.jQuery(this). parent().attr( 'style' , apex.jQuery(this).attr('ir-data-style') ); } );
Execution Options
	Sequence	10
	Fire On Initialization	Yes

---

Region

Identification
	Sequence	40
	Title	Classic Report
	Type	Report
Source
	Location	Local Database
	Query Type	SQL Query
	Region Source	select emp.empno , emp.ename , emp.job , ( case emp.job when 'MANAGER' then 'cr-data-style="background-color: LightBlue;"' else null end ) as job_css from emp
Appearance
	Template	Standard

Report Column

Identification
	Column Name	JOB
	Type	Display as Text (escape special characters, does not save state)
Heading
	Heading	Job
Column Formatting
	HTML Expression	<span #JOB_CSS#>#JOB#</span>
Security
	Escape Special Characters	Yes

Report Column

Identification
	Column Name	JOB_CSS
	Type	Hidden
Security
	Escape Special Characters	No

Dynamic Action

Identification
	Name	CR After Refresh - Set data-style
Execution Options
	Sequence	40
When
	Event	After Refresh
	Selection Type	Region
	Region	Classic Report
Advanced
	Event Scope	Static
True Action
Identification
	Action	Execute JavaScript Code
Settings
	Code	apex.jQuery("span[cr-data-style]").each( function() { apex.jQuery(this). parent().attr( 'style' , apex.jQuery(this).attr('cr-data-style') ); } );
Execution Options
	Sequence	10
	Fire On Initialization	Yes