Conditional Formating - Enter text into 3 cells to turn text colour black

**snoopy1461** · 06-02-2011, 10:48 AM

Im looking for a formular that when text has been entered into cell's B1, C1 & D1 the cell A1 text colour turns black.

Is there a formular for this?

**NBVC** · 06-02-2011, 10:50 AM

Try

=AND($B1<>"",$C1<>"",$D1<>"")

**ABSTRAKTUS** · 06-02-2011, 10:51 AM

You can do it with conditional formating. If cell is blank, it will use your default font colour (preset), if not you can set it black.

**snoopy1461** · 06-02-2011, 11:03 AM

Its work a treat, thanks

Re: Conditional Formating - Enter text into 3 cells to turn text colour black