Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Highlight cell value based on other cell value in APEX 21.2

HarikanthKonetiOct 12 2022

Hi Folks,
i'm using APEX version 21.2.
As per client requirement we're currently converting html page to APEX page.
in background of html we have below code
SELECT CASE
WHEN Rec.Time_Taken > Rec.Avg_Time THEN
'#FF4000'
WHEN Rec.Time_Taken > (((Rec.Avg_Time) * 70) / 100) THEN
'#F3F781'
WHEN Rec.Time_Taken < (((Rec.Avg_Time) * 70) / 100) THEN
'#A9F5A9'
ELSE
'white'
END,
CASE
WHEN Rec.Time_Taken > Rec.Avg_Time THEN
'white'
WHEN Rec.Time_Taken > (((Rec.Avg_Time) * 70) / 100) THEN
'#6f6f6f'
WHEN Rec.Time_Taken < (((Rec.Avg_Time) * 70) / 100) THEN
'#6f6f6f'
ELSE
'#6f6f6f'
END
INTO v_Urgeny, v_Word
FROM Dual;

Above color coding is applied on a column Time_Taken with below code

'<td style="background-color:' ||
v_Urgeny || ';color:' || v_Word ||
';">' || Rec.Time_Taken || '</td>'

Finally column value looks like below in html page.
kindly help me how can we achieve this in APEX Interactive Reports.

img.PNGThanks,
Hari.

This post has been answered by fac586 on Oct 13 2022
Jump to Answer

Comments

Processing

Post Details

Added on Oct 12 2022
5 comments
267 views