Select the cells you want to temporarily highlight and then click FORMAT in
the menu and select CONDITIONAL FORMATTING. In CONDITION 1 change CELL VALUE
IS to FORMULA IS and use the following formula (Changing A1 to the currently
highlighted cell address):

=ISBLANK(A1)

Click the FORMAT command button, click the PATTERNS tab and select the color
flavor of your choice. Click OK to complete.


--
Kevin Backmann


"NFaye" wrote:

Is there a way that I can highlight cells temporarily with color until they
are selected or until they are filled in? I would like specific colors to
disappear once data has been entered into certain cells of the document so
that it can then be printed. Any help would be greatly appreciated. Thanks.