Conditional Format of Odd Visible Rows

M

mjones

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
 
J

Jim Cone

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" <[email protected]>
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
 
Top