Forum Discussion
FORMULA OR KUTOOLS QUERY
I have a column with names in it. The column does have repeat names. I need to make sure that when that name appears in the column, there is the same value in another column for all the names or rows with that same name.
Let's say the names are in D2 and down, and the other data in E2 and down.
Select D2:E100 or however far down you want.
The active cell should be in row 2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=COUNTIFS($D:$D,$D2,$E:$E,"<>"&$E2)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.Rows that violate the requirement will be highlighted.
HansVogelaar Thank you for the info, but it did not work. Here is what I am looking to do:
NAME DESIG Row 2 Smith MD Row 3 Jones PA Row 4 Smith DO Row 5 Jones PA I need the formula to look at all Names in the Column, and if there is more than 1 record that has a different DESIG, then highlight. So with the case above, Smith would be highlighted, and Jones would not.
This is the result of the rule that I proposed, adjusted for columns A and B:
Workbook attached below. Is this not what you want?
