Hi Marcelo,

Thanks for this. However, I cant work out how to make it work using text
phrases instead of a list of numbers. Any ideas?

P.

"Marcelo" wrote:

Hi,

here a tip to have 6 without macro, more than it just with a vb code
http://mcgimpsey.com/excel/conditional6.html

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"plf100" escreveu:

Can I have more than 3 conditions for multiple formatting? If so, can anyone
tell me how? I have 4 potential text phrases to choose from a drop-down list
and would like each to be coloured appropriately

Many thanks.
P.