Conditional Formatting - Given dates within certain range of days
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!
|