Highlight Alternating Days

  • Thread starter Thread starter Dan
  • Start date Start date
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,
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to create a time sheet with clickable buttons 1
Leaker claims Intel launching powerful 'Core i9 Skylake X' processors in June 0
How do I include Nightshifts on a daily timesheet 8
Trailing 30 days sum calculation with excel 1
Daily Time Sheets with Rounding 1
Excel Highlighting duplicates 0
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Excel High lightng dates in future, today and past 1

Back
Top