Color-coding specific time sensitive records

Question

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.&nbsp;I really appreciate any help, thank you!------------------------------AG------------------------------

jeffpeterson1 · Answer

Try this in the formula for color-coding:

If(Today() &gt; [Closing Date], "purple",Today() &gt;= [Closing Date] - Days(7), "red",Today() &gt;= [Closing Date] - Days(30), "yellow")------------------------------Jeff Peterson------------------------------

Forum Discussion

Color-coding specific time sensitive records

1 Reply