Colouring cells dependent on an IF staement

[bridgera]

I need to colour a list of cells differently depending on their content. I'm sure I've seen this done automatically before, but I'm not sure how.

Does anybody know?

Thanks
Ross

 

[masim]

hie

Check format>conditional formating...

this will however, allow you to have only three conditions..

Regards
Asim

 

[bridgera]

Thanks - 3 statements will be plenty.
Cheers
Ross