View Single Post
 
Old 07-09-2014, 08:13 AM
SarahBear SarahBear is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jun 2014
Posts: 13
SarahBear is on a distinguished road
Default

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.
Reply With Quote