Hi,

I want add a colour to a cell when I input a certain value the only
problem is that I need this for 5 colours is there any way I can do
this as conditional formatting only seems to allow me to do it for 3
values.

Thanks,
Max


--
babygoode
------------------------------------------------------------------------
babygoode's Profile: http://www.excelforum.com/member.php...o&userid=26109
View this thread: http://www.excelforum.com/showthread...hreadid=467800

The most you can do is four colours.
You can use the three conditional formatting rules PLUS you can colour
the cell. If none of the conditions are met then the default
colour/format will apply.


--
flydecoder
------------------------------------------------------------------------
flydecoder's Profile: http://www.excelforum.com/member.php...o&userid=27288
View this thread: http://www.excelforum.com/showthread...hreadid=467800