Highlight a unique value with duplicate entries

[scotland9]

Hi all,

I am trying to highlight entries where a unique account number has unique location and highlight a unique account number with a duplicate location in a different colour.

is there a way to do this?

example.jpg

Your help is greatly appreciated!



***Solution below worked! thank you!!***

[6StringJazzer]

Yes. You can do this with conditional formatting using a custom formula with the COUNTIFS function. Based on your text description I would apply the following formula to the range A1:Bx where x is the highest possible row you would use, and use red fill:

Please Login or Register  to view this content.

Your default fill can be green fill. Then you only need one conditional formatting rule.

I can't reconcile your description to the image. Row 5 is an account number with a unique location yet is colored the same as the account number with duplicate locations.

[6StringJazzer]

Thanks for the rep, and thanks for marking your thread Solved!