See Bob Phillips' VBA solution in a thread earlier today

http://tinyurl.com/exryx


"NZJen" wrote:

I have a spreadsheet that I need to colour code specific cells if they meet a
certain condition. I know I can use conditional formatting but only 3
conditions can be met that way. I need to put in conditional formatting to
accept 6 different colours. How can I do this????