I was hoping someone could help me, seems simple but I can’t find a solution!
I have two lists of reference numbers; I need to see if any of the references appear in the other list. I don’t want them to be removed, maybe highlighted?
I have made them into one list and used the duplicate conditional formatting but some references appear twice in one list and there is a lot of data so this is not good enough.
Thanks in advance
Jess
Assuming that your first list is in column A starting on A2 and your second in column B, then highlight range A2:A100 and in CF rules use this.
Formula:
Please Login or Register to view this content.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you!
List one = A3:10186
List two = D3:D1879
I want list two to be highlighed. Do you know what the formula would be?
Thanks for your help! Much Appreciated
Last edited by JessK; 04-04-2014 at 03:28 AM.
Done it!
Thanks again for your help!!!!
Highlight the range D3:D1879.
Use this formula in CF rules
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks