I have done this by creating a rich text formula field. I created a new field "Billable..." I have the field "Billable". This has a value of Yes or No. If yes I want the color to be green, if no red.
This is the formula I am using
Case([Billable], "Yes", "<div style=\"color:white; background-color:#27AE60;\"> Yes</div>",
"No","<div style=\"background-color:#FF6666;\">No</div>",
"Medium", "<div style=\"background-color:#FF9999;\"> Medium</div>",
"Low","<div style=\"background-color:#FFCCCC;\"> Low</div>", "")
------------------------------
Ed A Mathias
VP of OPS
Athena Technology Solutions
Fremont CA
------------------------------
Original Message:
Sent: 01-12-2020 22:27
From: Ron McLemore
Subject: Color coding a field rather than the entire record in a report.
I have a date field [Date_Action1_Complete] and a text field [Action1_Description}. When the action is completed, the user enters the date completed in the [Date_Action1_Complete] field. There may be 20 or 30 of these data-action field pairs.
I am trying to create a report that highlights those date fields that are null so they are easy to identify. For example, if [Date_Action1_Complete] is empty, the [Date_Action1_Complete] field will have a yellow background color.
Thanks in advance,
Ron McLemore