The only way would be to use conditional formatting.
Click "Format/Conditional Formatting" and enter your conditions and formats.

Signature
Pops Jackson
> How do I enter a formula in a text cell without changing the text?
Enter the formula. Format>Cells>Custom, in the Type box, enter "text"
(replace text with your text)
If this is not what you mean, tell us what you're trying to achieve

Signature
Kind regards,
Niek Otten
Microsoft MVP - Excel
| How do I enter a formula in a text cell without changing the text?