View Single Post
 
Old 07-09-2014, 09:40 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by SarahBear View Post
I figured it out!
Okay, you just highlight both lists, go into conditional formatting, new rule, "use a formula to determine which cells to format", then enter in the formula "=$A1<>$B1", set your formating however you want it to show the values that don't match, and hit ok.
Lovely! I hadn't thought of that. Well done! That's what I'll do from now on.
Reply With Quote