conditional formating if field is blank

  • Thread starter Thread starter sfleck
  • Start date Start date
S

sfleck

i would like to to format a cell if it is blank to bright background to bring
attention to it
 
I guess setting the default to the color you want will work and changing if
the field contains text
 
i would like to to format a cell if it is blank to bright background to bring
attention to it
Click to expand...

Select the control on the form you wish to conditionally format.
Click on Format + Conditional Format.
Set Condition1 to
Expression Is
write in the next box
[FieldName] Is Null
Select the color you wish
Save teh changes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Conditional format of a control 2
My worksheet automatically adds a fill color when I enter text. 1
Is Null Testing for Combo On Opening Form 10
Excel Conditional Formatting 1
Excel Named Ranges and Conditional Format 3
Question about conditional formatting of zeros in Excel 0
Conditional Formatting 3

Back
Top