Conditional formating formula

[Mike]

I wanted to highlight every other row automatically. The
formula =ISEVEN(CELL("row",A2)) returns TRUE value when
pasted into cell A2, but it creates error message when
used in the Conditional Format dropdown box. Is there
another way to conditionally format every other row?

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/banding.htm
or enter the following as formula in the conditional format dialog
=MOD(ROW(),2)=0

HTH
Frank

 

[Gord Dibben]

Mike

Select all the rows you want alternately formatted.

In the "cell formula is" enter this......

=MOD(ROW(),2)=1

Pick a color from Format>Patterns.

Gord Dibben Excel MVP