Multiple Color-Coding Formula within a report

Question

I'm trying to create a formula in a report to highlight certain colors based on proximity to a date.
If([Escalation Date]&lt;Today(),"red", [Escalation Date]&gt;Today xxxxx,"Yellow")&nbsp; The xxxx is what I'm having issues with.&nbsp; I want the row in the report to highlight Yellow if Escalation Date is within 3 days of now.&nbsp; Example:&nbsp; If today is the 8th, and the Escalation Date is within 3 days, then highlight yellow.&nbsp; This is the current formula:
If([Escalation Date]&lt;Today(),"Red",[Escalation Date]&gt;Today()+Days(3),"Yellow")
The Red works as expected, but the Yellow highlights everything else.&nbsp; I just want it to highlight items within 3 days of Today.&nbsp; I hope that makes sense.
------------------------------Tony Miller------------------------------

markshnier__you · Answer

try bthis

&nbsp;
Community Home
Discussion&nbsp;59K
Library&nbsp;418

Toggle navigation&nbsp;Settings

&nbsp;Back to discussions

Expand all&nbsp;|&nbsp;Collapse all

Multiple Color-Coding Formula within a report

1.&nbsp;

0&nbsp;Like

Tony Miller

Actions&nbsp;Options Dropdown

Posted 3 minutes ago

ReplyOptions Dropdown

I'm trying to create a formula in a report to highlight certain colors based on proximity to a date.
If([Escalation Date]&lt;Today(),"red", [Escalation Date]&gt;Today&nbsp;xxxxx,"Yellow")&nbsp; The xxxx is what I'm having issues with.&nbsp; I want the row in the report to highlight Yellow if Escalation Date is within 3 days of now.&nbsp; Example:&nbsp; If today is the 8th, and the Escalation Date is within 3 days, then highlight yellow.&nbsp; This is the current formula:
If([Escalation Date]&lt;Today(),"Red",[Escalation Date]&lt;=Today()+Days(3),"Yellow")

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

tonymiller · Answer

Perfect.&nbsp; That worked.&nbsp; I figured it was something simple.------------------------------Tony Miller------------------------------

Forum Discussion

Multiple Color-Coding Formula within a report

Multiple Color-Coding Formula within a report

1.