Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2020, 11:13 PM
Marcia's Avatar
Marcia Marcia is offline Conditional formatting formula that highlights different values among two columns Windows 7 32bit Conditional formatting formula that highlights different values among two columns Office 2013
Expert
Conditional formatting formula that highlights different values among two columns
 
Join Date: May 2018
Location: Philippines
Posts: 257
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Reply With Quote
  #2  
Old 02-17-2020, 04:15 AM
ArviLaanemets ArviLaanemets is online now Conditional formatting formula that highlights different values among two columns Windows 8 Conditional formatting formula that highlights different values among two columns Office 2016
Expert
 
Join Date: May 2017
Posts: 545
ArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the rough
Default

Here you go!
Attached Files
File Type: xlsx ConditionalFormat.xlsx (10.0 KB, 3 views)
Reply With Quote
  #3  
Old 02-17-2020, 11:47 PM
Marcia's Avatar
Marcia Marcia is offline Conditional formatting formula that highlights different values among two columns Windows 7 32bit Conditional formatting formula that highlights different values among two columns Office 2013
Expert
Conditional formatting formula that highlights different values among two columns
 
Join Date: May 2018
Location: Philippines
Posts: 257
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you Arvi. It works perfectly. It took me some time to get the role of <>$B2.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting formula that highlights different values among two columns 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


All times are GMT -7. The time now is 12:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft