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?
|