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
|