Previous Topic Next Topic

Highlight dates with conditional formating

Closed
chdm2013
Posts
2
Registration date
Tuesday June 25, 2013
Status
Member
Last seen
June 26, 2013
 - Jun 25, 2013 at 09:57 AM
CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5= 09-JAN-2013, A6= 10-JAN-2013

Here a1 and a2 has difference of 1 day so both the cells a1, a2 should be highlighted with same color (blue), cell a3 and a2 has more than 1 day difference so cells a3 should be highlighted with separate color (cell a3=green), cell a4 and a3 more than 1 day difference so cells a4 should be highlighted with separate color (orange).