I use formula =MOD(ROW()-9,1*2)+1<=1 as a conditional format in order to have rows of alternating color, but I can't get other conditions to work in the colored row??
When I set up a condition where the word "OVDUE" will turn red and bold it only works in the rows that are not colored--in the green rows in does not change???
This message was edited by em on 2002-04-11 13:37
This message was edited by em on 2003-01-31 23:36
This message was edited by em on 2003-02-01 00:01
When I set up a condition where the word "OVDUE" will turn red and bold it only works in the rows that are not colored--in the green rows in does not change???
This message was edited by em on 2002-04-11 13:37
This message was edited by em on 2003-01-31 23:36
This message was edited by em on 2003-02-01 00:01