Conditional Formatting of Text...

[Guest]

....I know how to apply Conditional Formatting to cells containing numeric
data; is it possible to apply it to cells where the result is textual? For
example:
=if(a1>=5000,"High","Low")
In this instance, I would want to conditionally format this cell so that if
the result is High, then the text should be bold and red. Thanks in advance.
I'm using Excel 2002...

 

[JulieD]

Hi

click on the cell
choose format / conditional formatting
choose
cell value is
equal to
="high"
click the format button
set your formatting
click OK twice

Regards
JulieD

 

[JE McGimpsey]

One way:

CF1: Cell value is equal to ="High"
Format1: Bold, red

 

[Guest]

Great! Thanks for your very prompt replies - just what I wanted.