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