View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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

"Birmangirl" wrote in message
...
...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...