Forum Discussion
Conditional Formatting possibly
Hi guys I'm setting up my work schedule in excel so I can have an over view of my shifts I have my set up complete i.e.. A1&B1 Merge = Day, A2&B2 = Date, A3= start, B3=End, this is repeated across t...
The easiest thing to do is insert a column to the left of column A. Highlight the range (should now be B2:O4) then in conditional formatting you want a new rule and based on formula. The formula will be something like:
=(B$3<>"")*ISEVEN(COLUMN(B$3))+(A$2<>"")*ISEVEN(COLUMN(A$2))
which basically is always checking row 3 and either the cell in the same column (e.g. B3) if that column is even or the cell is the column before (e.g. A3) if this column is odd. as you can see adding that extra column to the left and pushing everything over 1 column makes it easier to check both this column and the column before (which wouldn't be possible if the range started in column A)