I'm trying to use conditional formatting to highlight duplicate cells but only when a corresponding cell in the same record is different than the 1st one. Here's a picture of what I'm trying to do.
Notice that the SN field gets highlighted for duplicate SNs, but ONLY when the corresponding date fields is different. I'm thinking it's gotta be some for of DCount that looks like this, but can't figure out how to add the second field condition. Note that all fields are text fields.
Notice that the SN field gets highlighted for duplicate SNs, but ONLY when the corresponding date fields is different. I'm thinking it's gotta be some for of DCount that looks like this, but can't figure out how to add the second field condition. Note that all fields are text fields.
Code:
DCount("*", "NameOfTable", "[NameOfField]=" & Chr(34) & [NameOfField] & Chr(34)) > 1