Conditional formatting - Blank entries

Jennacat

Registered User.
Local time
Today, 15:12
Joined
Mar 19, 2008
Messages
58
I have a quick question - I need to highlight empty fields (no entry = Color). How do I do this? I have tried Conditional Formatting, but it doesn't want to work unless I type NA into every blank space. Is there a way around this? I will be working with a very large table that has MANY blank entries (What has been done, what hasn't). What we still need to do needs to be highlighted. I was also wondering if there was a way to highlight another column. For example:

Product Code Fish Study Algae Study BOD
apr123 C C
apr456 C C C

Where the Product Code would also be highlighted if there was a blank entry. Can this be done? Thanks for your help!

ps. I inserted the table as a subform and have it displayed in datasheet view.
 
Under the format menu, and conditional formatting:

Pick your field you want to apply it to. For Condition 1 choose "Expression Is" and in the box to the right put: IsNull(FieldName.Value)

Where FieldName is the name of the field you are checking.

So that shows you how that will work - however, if you have tons of fields and want to highlight a different field, you need to do this in the box in contitional formatting:

IsNull(Field1.Value) Or IsNull(Field2.Value) Or IsNull(Field3.Value), etc..
 
Thanks

Thanks! This will work! :)
 
Just one more question......... I switched they way we are going to do things. Instead of a blank, it will be filled in by an X, since not every product needs every test. How do I get the product code to be highlighted if there is an X in the same row (alerts users that there is an unfinished study)?
 

Users who are viewing this thread

Back
Top Bottom