colour alternate rows in filtered list
-----Original Message-----
Hi
try the following:
- row 1 is the heading row
- column A is the filtered column
- select row 2:x
- goto 'Format - Conditional Format'
- enter the following formula:
=MOD(SUBTOTAL(3,$A$2:$A2),2)
- choose a fomat
-----Original Message-----
In VBA, how would I change the interior colour of
alternate rows in a filtered list ie. visible rows only?
Thanks,
Rosemary
.
.
Frank
|