AMENDMENT to my Conditional Formatting Question

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

Okay, so I figured out how to have a field be highlighted if it doesn't equal
another field.... but what do I do if the field is blank? For instance...

Field 1 Field 2
Verbal Warning

If I want to highlight both these fields because they do not equal, how do I
do that? Currently, my conditional formatting does not highlight either field
in this situation.

Thanks!!!
 
Try using an expression - either one of the following should work.

Expression is
Nz([Field1],"") <> NZ([Field2],"")

OR

Expression is
[Field1] & "" <> [Field2] & ""


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Worked PERFECTLY. Thank you!!!!!!!

John Spencer said:
Try using an expression - either one of the following should work.

Expression is
Nz([Field1],"") <> NZ([Field2],"")

OR

Expression is
[Field1] & "" <> [Field2] & ""


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Okay, so I figured out how to have a field be highlighted if it doesn't equal
another field.... but what do I do if the field is blank? For instance...

Field 1 Field 2
Verbal Warning

If I want to highlight both these fields because they do not equal, how do I
do that? Currently, my conditional formatting does not highlight either field
in this situation.

Thanks!!!
Click to expand...
Click to expand...
 
Back
Top