Excel - How to Use Conditional Formatting With IF Statement - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

just trying to use Conditional Formatting to compare items listed in column F to items listed in column G (1 for 1) to highlight/find the ones that that are duplicate. For example, I just want to know if F2 and G2 are a match, NOT if F2 has ANY matches in the entire column of G...
Solved by F. Y. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/08/2018 - 08:38
Hello, how are you?
User 08/08/2018 - 08:39
I'm good, I work for the government so I cannot share my data...i just need a little push in the right direction
Excelchat Expert 08/08/2018 - 08:40
Sure, no pressure, let me design a formula for you and then guide you on how to use it
User 08/08/2018 - 08:41
and I can use this formula with Conditional Formatting? Did my question make sense to you?
User 08/08/2018 - 08:41
I work in medical supply chain, nothing secretive or crazy
User 08/08/2018 - 08:41
the list is 57 thousand rows long, I just need to weed out the duplicates
User 08/08/2018 - 08:42
and focus on those that are not the same
Excelchat Expert 08/08/2018 - 08:43
Yes, very sensible. the formula will be used to compare columns F and G and highlight the ones that have the same values in Green color, is that okay?
User 08/08/2018 - 08:44
yup and it's just one for one, not the entire columns against each other...
Excelchat Expert 08/08/2018 - 08:44
Sure, reverting shortly
User 08/08/2018 - 08:45
I do want both columns to compare to each other though, so the formula has to include the entire 57k rows...
Excelchat Expert 08/08/2018 - 08:48
Are you there?
User 08/08/2018 - 08:49
yes sorry
User 08/08/2018 - 08:49
did I miss something?
Excelchat Expert 08/08/2018 - 08:49
Select all the data in columns F and G
User 08/08/2018 - 08:49
Excelchat Expert 08/08/2018 - 08:50
Then select conditional formatting
User 08/08/2018 - 08:50
Excelchat Expert 08/08/2018 - 08:51
Choose new rule
User 08/08/2018 - 08:51
Excelchat Expert 08/08/2018 - 08:52
Click on "choose a formula to determine which cells to format"
User 08/08/2018 - 08:52
User 08/08/2018 - 08:53
im sorry, give me 3 mins, I need to use the washroom
Excelchat Expert 08/08/2018 - 08:54
Wait first so that you may extend the session
Excelchat Expert 08/08/2018 - 08:54
You will get the option shortly
Excelchat Expert 08/08/2018 - 08:55
You need to accept the extension so that we may continue with the explanation
User 08/08/2018 - 08:56
i'm back
Excelchat Expert 08/08/2018 - 08:56
Okay, type =F1=G1
User 08/08/2018 - 08:56
sorry, too much coffee, lol
Excelchat Expert 08/08/2018 - 08:57
Then click on "format"
User 08/08/2018 - 08:57
User 08/08/2018 - 08:57
sorry, didn't mean all caps
Excelchat Expert 08/08/2018 - 08:57
Click on "format"
User 08/08/2018 - 08:57
Excelchat Expert 08/08/2018 - 08:58
Select "Fill"
User 08/08/2018 - 08:58
User 08/08/2018 - 08:58
select a color?
Excelchat Expert 08/08/2018 - 08:58
User 08/08/2018 - 08:59
ok, done
Excelchat Expert 08/08/2018 - 08:59
Then click ok
User 08/08/2018 - 09:00
okay, let me look through this real quick, I don't see as many as I thought
Excelchat Expert 08/08/2018 - 09:00
How did it turn out?
User 08/08/2018 - 09:00
give me 1 min
Excelchat Expert 08/08/2018 - 09:01
Sure, confirm and revert with feedback
User 08/08/2018 - 09:02
okay, yes, I was mistaken of the percentage of duplicates, but that's on me...you did great
Excelchat Expert 08/08/2018 - 09:02
You are so welcome. Please remember to rate me well after ending the session. 5 stars in each category will be kind enough.
Excelchat Expert 08/08/2018 - 09:02
Am happy to serve you, have a nice time
User 08/08/2018 - 09:03
yes, I sure will, thank you so much...so I just hit "END SESSION"
Excelchat Expert 08/08/2018 - 09:03
Yeah, sure

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc