LinkBack URL
About LinkBacks
Please help me how can we find or highlight the duplicate value in two different sheets using conditional formatting. Awaited for your quick response.
thanks
Best Rgds,
Sukhdev Singh
Please help me how can we find or highlight the duplicate value in two different sheets using conditional formatting. Awaited for your quick response.
thanks
Best Rgds,
Sukhdev Singh
can you upload an example spreadsheet
are you looking to format 1 sheet if the same value in a cell on the 2nd sheet is found
if so, you could use vlookup() in the conditional format
=vlookup(A1,sheet2!A1:A200,1,false)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Highlight first range then click on the other tab, press Ctrl key and select second range. Go to Conditional Formatting, Highlight Cells Rules, Duplicate Values.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
CF does not work directly across sheets in 2007
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks