Conditional Format of Odd Visible Rows
 

Hi,

I use the formula =MOD(ROW(),2)<0 to change the colour of every other
row.

Now, I'm hidding some rows, so the formula doesn't work any more.

Does anyone know who to do the same thing, but count only visible rows?

For example

Row Colour
1 White
2 Blue
3 White
4 Blue
5 Hidden
6 White
7 Blue

Thanks,

Michele

Conditional Format of Odd Visible Rows
 

The free Excel add-in "Shade Data Rows" can shade by cell value,
every nth row or every nth row-group. It provides an option to
shade all rows or just the visible rows. Choice of any color.
Download from ... http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA


"mjones"
wrote in message
Hi,
I use the formula =MOD(ROW(),2)<0 to change the colour of every other
row.
Now, I'm hidding some rows, so the formula doesn't work any more.
Does anyone know who to do the same thing, but count only visible rows?
For example

Row Colour
1 White
2 Blue
3 White
4 Blue
5 Hidden
6 White
7 Blue

Thanks,
Michele