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.
6 Replies
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?
