I have a project where cells A and B have a part number and a quantity. I want to be able to paste a similar list in cells D and E. What I am trying to find out is if the list in A and B match D and E. If something doesn't match then I would like to highlight the cells in red.
Ive added an example but keep in mind that sometimes the list isn't going to line up. What I mean by that is sometimes A and B list will be longer than D and E and vise versa.
-Andy
You can use conditional formatting for this purpose.
Apply the ruleto the range $E$1:$E$9Formula:
Please Login or Register to view this content.
And apply theto the range $D$1:$D$9Formula:Please Login or Register to view this content.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Or try this......
Select A1:E9 and make a New Rule for conditional formatting using the formula given below and set format as per your choice.
Or this...
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sktneer; 07-25-2014 at 02:43 PM.
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.
So can I make this into a macro somehow. This is going to be used over and over?
Ignore the above question. I see how conditional formatting can help me here. My new question is this.....
The pasted data in columns D and E may not always line up with A and B meaning that the part number list may have an additional part number in between the last correct match and the next part number. What I would like it to do i have the capability to comb thru the D and E and tell me what what isn't in A and B that doesn't match.
See a newly uploaded example.
Last edited by agengler11; 07-25-2014 at 08:17 PM.
Select D1:E63 and set a New Rule for conditional formatting using the formula given below and set formatting as per your choice.
Please Login or Register to view this content.
Thanks to you all. I am using the example posted by SKTNEER but gave you both some Rep Points.
You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks