Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format question | Excel Discussion (Misc queries) | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Formating. Remove condition, keep format? | Excel Discussion (Misc queries) | |||
Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) |