ddb wrote:I did something like this a few months ago to put values < 0 in red. Try something like
I'm using APEX 4.1.
I would like to hilite any updateable cells in the form where the value in the cell is not '0.00'. This is not an error condition. It is just meant to assist the user review relevant entries.
A style sheet would probably be more elegant but this should be easy
select case when to_char(amount) != 0 then '<font color=red>'||to_char(amount)||</font>' else to_char(amount) end;