Forum Discussion

Gelo's avatar
Qrew Trainee
3 years ago

Color-coding specific time sensitive records

Hello Everyone,

I have a table report that the sales team uses to work through deals. I know we can create a formula for color-coding the records, just not sure what the formula would be.

We want to color-code records like so: If the today's date is 1 week before [Closing Date] highlight red. If today's date is a month before [Closing Date], highlight yellow, etc. Once that date has passed, highlight another color. 

I really appreciate any help, thank you!


1 Reply

  • Try this in the formula for color-coding:

    Today() > [Closing Date], "purple",
    Today() >= [Closing Date] - Days(7), "red",
    Today() >= [Closing Date] - Days(30), "yellow"

    Jeff Peterson