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

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