|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
Conditional formatting formula that highlights different values among two columns
Hi all. A table has columns A and B. Under A is a list of names. The same name may be repeated more than once. Column B contains a single information pertaining to each name in A.
A B Mary Out of town Mary Out of town Mary Deceased Abe Deceased Abe Deceased I need help in creating a formula in column B that would highlight an information about the name in A that is not the same with the first. Like in the third info about Mary, it is Deceased not Out of Town. The first info on Mary is Out of Town so the Conditional formatting should highlight Deceased. Thank you. |
#2
|
|||
|
|||
Here you go!
|
#3
|
||||
|
||||
Thank you Arvi. It works perfectly. It took me some time to get the role of <>$B2.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting that highlights cells when there was a change in another column | Marcia | Excel | 4 | 04-28-2019 07:34 AM |
Copying values that have conditional formatting applied | Cosmo | Excel | 10 | 02-24-2017 06:27 AM |
Conditional Formatting Multiple Or Values | Phil H | Excel | 4 | 05-21-2015 04:16 AM |
Conditional Formatting for values with more than 2 decimals | lynchbro | Excel | 6 | 04-17-2015 06:05 AM |
Conditional Formatting for columns | MattMurdock | Excel | 1 | 08-09-2012 10:03 PM |