**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

ok

Excelchat Expert
08/08/2018 - 08:50

Then select conditional formatting

User
08/08/2018 - 08:50

ok

Excelchat Expert
08/08/2018 - 08:51

Choose new rule

User
08/08/2018 - 08:51

ok

Excelchat Expert
08/08/2018 - 08:52

Click on "choose a formula to determine which cells to format"

User
08/08/2018 - 08:52

ok

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

OK

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

ok

Excelchat Expert
08/08/2018 - 08:58

Select "Fill"

User
08/08/2018 - 08:58

ok

User
08/08/2018 - 08:58

select a color?

Excelchat Expert
08/08/2018 - 08:58

Sure

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.*