View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Multiple conditions for conditional formatting

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.