You can use conditional formating (menu Format) in A1, set the condition with
"Formula Is" and use the following formula:
=ISBLANK(B1)
Then set the format as you want it in the Format button.

Hope this helps,
Miguel.

"savbci" wrote:

> I have 2 fields A1 and B1
> If B1 is blank I want the text in A1 to turn red. Otherwise it will remain
> black.
> Later if B1 is filled in then A1 will turn back to it's original state
> (black).
> How do I do this?
>