How does a cell automatically highlight itself after entering numb

[Janet]

Our office cannot figure out how! We've tried everything.
Thanks so much!

[Norman Jones]

Hi Janet,

See Debra Dalgleish's Conditional Formatting tutorial at:

http://www.contextures.com/xlCondFormat01.html


---
Regards,
Norman


"Janet" <[email protected]> wrote in message
news:[email protected]...
> Our office cannot figure out how! We've tried everything.
> Thanks so much!

[George]

Most likely using Conditional Formatting under the Format Menu
Read the Excel Help

Enter this conditional format for cell A1 & copy

Change the "Cell Value Is" to "Formula is" and enter the following in
the reference section. (either 1 should work)
=NOT(ISBLANK(A1))
or
=A1<>""

Then select what format you want when data is entered eg. Fonts ,
Patterns, Borders etc.


George

Janet wrote:
> Our office cannot figure out how! We've tried everything.
> Thanks so much!