Conditional Formatting

[babygoode]

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

 

[flydecoder]

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