Conditional Formatting Shading For Visible Rows Only

Giganews Newsgroups
Subject: Conditional Formatting Shading For Visible Rows Only
Posted by:  manda (a_bue…@hotmail.com)
Date: 17 May 2006

I am using conditional formatting formula =MOD(Row(),2)=0 to shade
alternate rows, but when I hide a row the shading format is not
consistent. Is there way to shade alternate 'Visible Only' rows without
creating a macro?

Replies