|
|
#4
07-09-2014, 08:13 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| Conditional Formatting | jdc15371 | Excel | 2 | 06-26-2014 06:34 AM |
|
Compare content of two ranges INCLUDING FORMATTING
|
delasson | Word VBA | 3 | 12-10-2012 03:54 AM |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode