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
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
> 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
JackD - 16 Mar 2006 18:51 GMT
Thanks for your help.
> Conditional formatting will do the trick
>
[quoted text clipped - 10 lines]
> > Thanks for your help.
> > JD