Want temporary color in cells needing attention

N

NFaye

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.
 
K

Kevin B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting of cells with a specific color filled 9
Automatically color merged cells 1
Color in cells 3
Cells Won't Highlight when selected 2
Sorting by Color in Excel 2003 5
Changing the color of highlighted cells 1
Creating a formula to highlight a row of cells 3
Change cell fill color options 1

Top