|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Alternate Row Shading (Visible Rows Only)
Have a look here
http://www.contextures.com/xlCondFormat03.html#Shade
Mike
"Forgone" wrote:
Quick question..... hopefully it is possible.
To have alternate row shading in XL2003 and earlier the conditional
formatting formula would be =MOD(ROW(),2)
This works find until I start hiding rows.....
Is there a way to have alternate row shading on visible rows?
This is so that I can retain the alternate row shading even if I start
to hide rows.
|