If I apply conditional formatting to say cells A6:A20 then that works ok.
But as I have 20 columns it would be easier to do all 20 at once by highlighting them.
However it is every other column that I need to do.
Example:
A6:A20
C6:C20
E6:E20
When I highlight the 3 columns cells 6:20 the conditional formatting doesnt work.
Would this be correct or am I doing something wrong?
thanks
Bookmarks