View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Multiple conditions for conditional formatting

P.,
if it is only 4 then you can use the cell's standard format for one of
the phrases and conditional formatting for the remaining three.

If this does not help then you will need VBA. A Worksheet_Change macro,
which will automatically apply the format if the cell changes. For a
full code write back if the suggestion does not suit you, with the
formatting changes you want in each of the 4 cases.

HTH
Kostis Vezerides