select the cell you want to have a background colour in, go to the Format
menu and select conditional formatting, set 'Cell Value Is' to 'Formula Is'.
enter the formula =(which ever cell you are setting i.e. B5)="". Now press
format and set your required background colour and border etc. To copy this
to another cell ensure the cell reference is entered like B5 and not $B$5 (it
will enter $B$5 if you click on the cell when writing the formula rather than
typing B5), then select the cell which has the conditional format, click the
format painter icon (paint brush) and click on the next cell.

"mlsintx" wrote:

I want to identify where a user should enter data in a workbook/sheet. Fill
color would work great but I don't want it to print. Any ideas or
suggestions?