SUJU
10-10-2005, 07:18 PM
Hi
I have a fairly large data spreadsheet (8 sheets) and want Excel to
automatically color in every alternate row in colorcode 34 for ease of
reading. However, some of the columns are already coloured in other
colors based on their cell values. I need these colors to be superior
to the row color 34. I tried the following Cond Formating way, but the
row color takes superiority...How do i change this? I need the cell value color to be superior
=AND(MOD(ROW(),2),COUNTA($a5:$R200))
I have a fairly large data spreadsheet (8 sheets) and want Excel to
automatically color in every alternate row in colorcode 34 for ease of
reading. However, some of the columns are already coloured in other
colors based on their cell values. I need these colors to be superior
to the row color 34. I tried the following Cond Formating way, but the
row color takes superiority...How do i change this? I need the cell value color to be superior
=AND(MOD(ROW(),2),COUNTA($a5:$R200))