View Single Post
  #1   Report Post  
Tee51 Tee51 is offline
Junior Member
 
Posts: 19
Default 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!