| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Colors
I want a cell to automatically fill with a specific color when I type in it.
Is there a formula for this - or function that I am missing. Thanks for your help. JD |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill Colors
Conditional formatting will do the trick
Format Conditional Formatting Cell Value Is Not Equal To ="" Then click on the 'format' button and choose the Font, Border and Pattern that you want. George JackD wrote: I want a cell to automatically fill with a specific color when I type in it. Is there a formula for this - or function that I am missing. Thanks for your help. JD |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill Colors
Thanks for your help.
"George" wrote: Conditional formatting will do the trick Format Conditional Formatting Cell Value Is Not Equal To ="" Then click on the 'format' button and choose the Font, Border and Pattern that you want. George JackD wrote: I want a cell to automatically fill with a specific color when I type in it. Is there a formula for this - or function that I am missing. Thanks for your help. JD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing *permanently* Excel's colors and graph fill for charting? | Charts and Charting in Excel | |||
| Fill colors | Excel Discussion (Misc queries) | |||
| Excel: is there a way I can lighten the fill colors in a cell? | Excel Discussion (Misc queries) | |||
| How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) | |||
| Add fill colors: green & red & yellow on toolbar, instead clickin. | Excel Worksheet Functions | |||
Linear Mode
