Originally Posted by amkel

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