Fill Colors

J

JackD

I want a cell to automatically fill with a specific color when I type in it.
Is there a formula for this - or function that I am missing.

Thanks for your help.
JD
 
G

George

Conditional formatting will do the trick

Format > Conditional Formatting
Cell Value Is Not Equal To =""
Then click on the 'format' button and choose the Font, Border and
Pattern that you want.

George
 
J

JackD

Thanks for your help.

George said:
Conditional formatting will do the trick

Format > Conditional Formatting
Cell Value Is Not Equal To =""
Then click on the 'format' button and choose the Font, Border and
Pattern that you want.

George
Click to expand...
 
Top