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