I am working oracle apex 4.2 environment, where I am developing report, in which I wan to implement the color of row should change according to column value.
For example I was working with below query
select
case
when sal > 1000 then
'<span style=background-color:red>'
else
'<span style=background-color:green>'
end,
"EMPNO",
"ENAME",
"JOB",
"MGR",
"HIREDATE",
"SAL",
"COMM",
"DEPTNO"
from EMP
But it was not able to change the color of the row. Please guide me.