Skip to main content
Question

Color Code a Date Range

  • March 9, 2022
  • 0 replies
  • 18 views

MeaganMcOlin
Forum|alt.badge.img+7

I need a code that color codes a range of dates. For example:

+15 days through + 30 days should be yellow

+2 days through + 14 days should be orange

+ 1 day though overdue should be red

This is what I have to start with, but I don't know where to go from here: 

If([Approved End Date]=(Today()+Days(30)),"<div style=\"background-color:yellow;\">"&[Approved End Date]&"</div>",
ToText([Approved End Date]))

Any help would be greatly appreciated. 

Thank you!



------------------------------
Meagan McOlin
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • Quickbase Alumni
  • March 11, 2022
What type of field is this, or is this a report?

------------------------------
Jeff Peterson
------------------------------