Highlight based on multiple values in a column

[mlindquist]

Is there a way through conditional formatting to highlight a column value if they have multiple values in one of the other columns (ex. STATUS - they could have both an Active and Inactive status.

ID	ID_RCD	STATUS
123456	1	A	some data
123456	2	I	some data
123456	3	A	some data
456789	1	A	some data

 

[Joe4]

Let's say that your range shown up above is A1:D5.
Then select the range A2:D5 (all your data minus the header row), and go to Conditional Formatting and enter this Conditional Formatting formula:

=COUNTIF($A$2:$A$5,$A2)-COUNTIFS($A$2:$A$5,$A2,$C$2:$C$5,$C2)>0

and select your desired formatting color.

Your result should look like this: