I have a worksheet that has 24 cells representing 2 years of Month cells. Every six months we have to change cables to match a color code that somehow works on Odd and Even years every six months. What it is supposed to do is turn the cells white for OCT NOV DEC on an Odd year and JAN FEB MAR on an Even year. Over two years there are four colors that follow the above pattern.
So if this was 2008 then OCT NOV DEC would be Orange and JAN FEB MAR of 2009 would be also be Orange and then 2009 APR MAY JUN and JUL AUG SEP would also be Orange.
Hopefully this is clear enough to understand. I suspect that if I can simply figure out how to capture being able to figure out how to identify Odd an Even years I should be able to figure out the rest.
Thanks in advance.
So if this was 2008 then OCT NOV DEC would be Orange and JAN FEB MAR of 2009 would be also be Orange and then 2009 APR MAY JUN and JUL AUG SEP would also be Orange.
Hopefully this is clear enough to understand. I suspect that if I can simply figure out how to capture being able to figure out how to identify Odd an Even years I should be able to figure out the rest.
Thanks in advance.