Thread: Coloured text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Coloured text

Use Conditional Formatting.
Select the cell or cells you want to apply this formatting to.

Format-Conditional Formatting.
Cell Value Is - equal to - ="TOO HIGH"
Click the Format button and adjust as needed.

HTH,
Paul

"David Crawt" wrote in message
...
I have a formula which returns an answer of either 'O.K.' or 'TOO HIGH'

Is there a way that I can tell Excel to make the words 'TOO HIGH' show in
red?