Dear Roger,

I guess both of us are saying the same thing. It's just that I used spare
column which could have been avoided.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Ashish

I don't think this works in the manner required
If you don't bother with formulae in column C, but just set the
Conditional Formatting formula to
=MOD(SUBTOTAL(103,$B$2:B2),2)=0
then it will work.
--
Regards
Roger Govier

"Ashish Mathur" wrote in message
...
Hi,

Assume your data is arranged like this in range A2:B10.

Name Amount
A 10
S 12
D 14
F 16
G 18
T 20
Y 22
U 24

Now in C2, enter the following formula =SUBTOTAL(103,$B$3:B3). Copy this
down till C10. Now while in cell B3, enter the following formula in
Format
Conditional formatting =MOD($C3,2)=0. Select the format desired. Now
copy this conditional format down.

Try hiding rows now. You will mow notice that every even numbered row
which is visible, will be in the desired format.

Please let me know how this works for you. Also, please note that this
method will only work in Excel 203 and above. SUMPRODUCT(100 series
....) is only available in Excel 2003 and above.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Forgone" wrote in message
...
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.