Hi Tee51
For the conditional formatting rules.
Assuming your data is column A:
Rule 1 Between 12-15 days from today:
=AND($A1<"",$A1=TODAY()+12,$A1<=TODAY()+15)
Rule 2 Between 30-35 days from today:
=AND($A1<"",$A1=TODAY()+30,$A1<=TODAY()+35)
Kevin
Quote:
Originally Posted by Tee51
Hi,
Is there a way to highlight cells that have dates that are within 12 to 15 days and 30 to 35 days?
Example:
A1 = 2/7
A2 = 2/1
A3 = 1/19
A4 = 2/15
I would like cell a2 and a3 to be highlighted (preferably different colors).
Thanks in advance!
|