I want to color code text based on a date Bali and its relationship with Today() and +/- a number of days. One example, in XLS, this works:
Today - (the cell value) > 10
So if I take today less my date value, if it is greater than ten…then a cell is shaded.
How would I write it using Today() and its relationship to my date value (Last Contact Date) and whether it is + or - 10 (days).
I need to be able to do a variety of these type of format rules with adding and subtracting “x” number of days. Thank you.