Hey all,
I need to compare two columns (A,B) and conditional format column B if a duplicate is found in column A.
What's the best way to go about this?
Thanks!
Hey all,
I need to compare two columns (A,B) and conditional format column B if a duplicate is found in column A.
What's the best way to go about this?
Thanks!
Try using countif as part of your rule.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
To do this, select whole columns A:B and make a New Rule for conditional formatting using the formula given below and set the Format as per your choice.
For more details, refer to the attached.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks