| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Colour cell yellow when there is not data entered
I use Excel 2003
I have an application form that I send to the client. When the data boxes are blank then I want to format this as yellow so the client can see what is required to fill in the form. Also, can I do this for tick boxes. Please note that some of these boxes have some formatting in them so the rule needs only to apply when blank from alphanumeric characters. Thanks for some help in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Colour cell yellow when there is not data entered
Are you using a Userform, or is the form composed of cells to be filled it??
|
|
#3
|
|||
|
|||
|
Quote:
When you say some of the cells have some formatting in them, what kind of formatting? Could you post an example of the form? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofill colour based on date entered | Excel Discussion (Misc queries) | |||
| Can excel graphs be set to choose same colour i.e hols = yellow | Charts and Charting in Excel | |||
| Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? | Excel Programming | |||
| formula for if Cell c1 is yellow shaded cell d1 should be yellow | Excel Discussion (Misc queries) | |||
| if cell contains formula change background colour to pale yellow | Excel Programming | |||
Linear Mode
