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.

In Excel-shade the cell automatically when data is entered
 

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.