Forum Discussion
Duplicates in one column with different values in another column
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...
Anyone help me with this matter please, because I’m dealing with thousands of rows.
Thank you
Hi iMajeed
Will be glad to help but...
#1 i have attached the file. There's no file attached, a picture only
#2 i need from excel highlight entire row if the value contains TRUE and FALSE only. How can a formula in column T_F returns TRUE and FALSE? It's either TRUE or FALSE. Please clarify the condition (TRUE or FALSE in T_F) should be used to highlight the corresponding row
ThanksLorenzo for your reply, the ( techcommunity ) here not support the file (.xlsx) but i raised the excel file on onedrive via this link Book3.xlsx , let me clarify my inquiry more, for Example i have unit with number 23********** repeat 3 times ( Duplicates ) but in column ( L ) have value True also false , how can make the excel highlight the row for unit 23********** repeated 3 times but only if have value True also false in column ( L ) .
Thanks