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.