ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Colour cell yellow when there is not data entered (https://www.excelbanter.com/excel-discussion-misc-queries/446400-colour-cell-yellow-when-there-not-data-entered.html)

amkel

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

James Ravenswood

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??

Spencer101

Quote:

Originally Posted by amkel (Post 1603009)
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


When you say some of the cells have some formatting in them, what kind of formatting?
Could you post an example of the form?


All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com