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.