Nearly there

I've attached an example. The main driver for this is the Week column (note formula from C9 down. Once that is set up, highlight the whole table (not the header row) and your conditional formatting formula will be =mod($C2,2)=1. Once set up you can hide the Week column.

Incidentally, thank you for asking. I have just taken delivery of Office 2011 for MAC. I use 2007 for Windows in work and have been using 2003 at home. Bill Gates has moved everything around again so I had to do a bit of detective work. It will, no doubut, come in useful in work in a day or so.

Kind regards.

Tony

Attached Files

ConFormat.xlsx (54.3 KB, 28 views)