Use conditional formatting (Format | Conditional Formatting).

In the future, please type your question in the message box, not the subject
line--it's too short to read easily.

"Mike" wrote:

How do I go about doing this?