Hi,

For more CF's see this addin
http://www.xldynamic.com/source/xld.....Download.html

Cheers
Andy

Dave wrote:
Is there anyway you can get more than 3 colours to be displayed in the
cell?

David Biddulph wrote:

Set up your first condition and associated format, then hit the "Add" button
in the conditional formatting dialogue box.
--
David Biddulph

"Dave" wrote in message
groups.com...

I know how to use this in basics, say when the cell equals 1 change
colour to blue. How would you how ether change the colour again in the
same cell if the value was say 3, change it to green and so on?




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info