Forum Discussion
Solved
Duplicates in one column with different values in another column
I have excel sheet that have column with duplicate in one column and have different values in another column TRUE / FALSE in ( T_F ) column, i need from excel highlight entire row if the value contai...
OK, so a single Cond. Format. rule is enough:
- Deleted all existing Conditional Formatting rules on your Table
- Select all Columns + Rows of your Table
- Go to Home (tab) > Conditional Formatting > New Rule... > Use a formula to determine which cells to format
- Under Format values where this formula is true enter (adjust $A$2874 as necessary):
=AND(COUNTIF($A$2:$A$2874, $A2) > 1, NOT($L2))- Click on Format... at the bottom right > Choose how you want to format...
Yes!
OK, so a single Cond. Format. rule is enough:
- Deleted all existing Conditional Formatting rules on your Table
- Select all Columns + Rows of your Table
- Go to Home (tab) > Conditional Formatting > New Rule... > Use a formula to determine which cells to format
- Under Format values where this formula is true enter (adjust $A$2874 as necessary):
=AND(COUNTIF($A$2:$A$2874, $A2) > 1, NOT($L2))
- Click on Format... at the bottom right > Choose how you want to format...