Conditional formating formula

M

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?
 
G

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
 
Top