| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want temporary color in cells needing attention
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Want temporary color in cells needing attention
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Want temporary color in cells needing attention
Fantastic! Thank you so much! And such a quick response!
"Kevin B" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP needing to match two cells | Excel Worksheet Functions | |||
| Displaying temporary values on formula cells. Is this possible?q | Excel Discussion (Misc queries) | |||
| attention [email protected] re alphanumeric | Excel Worksheet Functions | |||
| Can I make a cell in the spreadsheet 'FLASH' to draw attention? | Excel Discussion (Misc queries) | |||
| Outlining in Protected Sheet - Attention DP | Excel Discussion (Misc queries) | |||
Linear Mode
