Highlight Alternating Days

D

Dan

I have a worksheet with card reads by date (clock in and clock out). Date is
in column A. Sometimes there are multiple clock in's and outs for each day. I
need to highlight every other day so I can visually keep each day seperated.
Please help.
Thanks,
 
S

Sheeloo

Choose the range to highlight
Choose conditional formatting
Choose Formula is and enter the formula
=mod(day($A1),2)=0 and choose the highlighting you want

note the $, that is crucial...
 
Top