I didn't know you had a paper on conditional format. The traffic lights look like fun. More reading for me. Thanks.

"Bob Phillips" wrote in message ...
or http://xldynamic.com/source/xld.CF.html#rows

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Epinn" wrote in message
...
For future reference
http://www.datapigtechnologies.com/f...teshading.html

You can also highlight every 5 rows or whatever number by changing the
formula.

Epinn

"Tim" wrote in message
...

Usaing excel 2000, how do I get alternate coloured rows without having to
select and colour each one??

Tim