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...
...however, the data required were not highlighted yet. Please, I need it to be highlighted or obvious enough just like the attached picture in your reply
In the files I shared the Cond. Format. rules are implemented (just replicate them in the right order) and the picture I posted reflects what they do. I don't see what else I can do (???). Or share you actual workbook and let me know if you want to go with the Helper column or not
Great. Is it possible to only have the false date is be highlighted row that is duplicated in column A with name "ordernumber" ?
- Thanks a lot for your help,
Best regards 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!