In Excel-shade the cell automatically when data is entered

I want to be able to enter data into a worksheet, and have the cell that I am
entering automatically change colors or shading.

highlight the entire document and select Format->Condition Formating.
Select "Formula Is" and enter this formula
=1-ISBLANK(A1)
Click on Format and go to the patterns tab to select the shading color you
want.
Click "OK"
Click "OK"

"Sandra" wrote:

> I want to be able to enter data into a worksheet, and have the cell that I am
> entering automatically change colors or shading.