Duplicate cells not formatting problem.

Davebro

Board Regular
Joined
Feb 22, 2018
Messages
135
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
Book3
AB
1AddictiveAddictive
2Blue Collar LadAdhuil
3Body PartsAesops Fables
4BustaamAir Commander
5Catherine ChroiAl Baahy
6ChurchellaAl Muqdad
7Classy AlAllegro Brillante
8Cloud KingAllonsy
9CluedoAlumni Lia
10**** And BullAmaysmont
11Court DriveAmazon Lady
12Cradle Of LoveAmerjeet
13Dark DreamerAngle Land
14Ebony MawAnjician
15Fast StepsAno Manna
16Fighter CommandAntiphon
17Fox FlameApache Outlaw
18Goal ExceededAraifjan
19Harswell DandyArnie Angell
20HatadoraArthurs Victory
21High OrderAsgards Captain
22Jungle RunAsh Wednesday
23KodebreakerAtbay
24Light Up Our StarsAtlantic Gamble
25MakaluAu Lait
26Marty The PartyAyurveda
27NemovBalmoral Lady
28Ocean QuestBang On The Bell
29Old ****Barley Cove
30PiqueBashful
31Safari DreamBe Here Now
32So MessiBeau Gars
33Stag NightBeeswings
34Steps In The SandBig Dream
35Streak LightningBig Gossey
36Summer SnowBillie Frechette
37TranquillitatisBilly Bathgate
38WafeiBilly Mcgarry
39YiengaaBint Havana Gold
40Blue Collar Lad
41Blueys Boy
42Boadicia
43Bobacious
44Bobby K
45Body Parts
46Bora Bora
47Bouncing Bobby
48Bramble Jelly
49Branding
50Breezy Zoff
51Bristol Hill
52Bustaam
53Cailin Saoirse
54Calamint
55Calm Waters
56Camacho Man
57Candy Warhol
58Captured
59Cardinal Zin
60Catherine Chroi
61Charli Sands
62Chartwells Lady
63Chick Flick
64Chiedozie
65Churchella
66Cinque Verde
67Clarita
68Classy Al
69Clear Aim
70Clever And Classy
71Clongowes
72Cloud King
73Cluedo
74Coachello
75Coast
76**** And Bull
77Cold Hearted
78Collective Power
79Colors Of Freedom
80Comfort Line
81Copper Mountain
82Cosmos Artist
83Court Drive
84Cradle Of Love
85Crazy *******s
86Crispy Cat
87Crowns Lady
88Cuban Secret
89Cues Beau
90Daffin
91Dagmar Run
92Dagoda
93Dancing Highlander
94Dark Dreamer
95Dark Mystery
96Dazzling Spirit
97Demanding Lilley
98Designer Cailin
99Devasboy
100Diamond Dreamer
101Dingwall
102Dion Baker
103Dire Wolf
104Doon The Glen
105Double Martini
106Doubletalk
107Dramatic Star
108Dream Selection
109Ebony Maw
110Elementary Charge
111Elinor Dashwood
112Em Jay Kay
113Emaculate Soldier
114Embarked
115Emperor Dream
116End Zone
117Enthrallment
118Epaulawn
119Esticky End
120Eva Rosie
121Eyeshadow
122Fairy Godmother
123Far Above Mary
124Fast Steps
125Fighter Command
126First Officer
127Fiver Friday
128Fleetfootsoldier
129Fleetingly
130Flying Panther
131For Pleasure
132Fox Flame
133Front Gunner
134Gabriellas Spirit
135Gainsbourg
136Ganton
137Gastronomy
138Gentileschi
139Gentle Whinny
140Gibbs Island
141Glamorously
142Glasses Up
143Global Effort
144Global Humor
145Glowing Bird
146Go Athletico
147Goal Exceeded
148Gobi Sunset
149Going Remote
150Gold Aura
151Grey Fox
152Haalim
153Hale Bopp
154Hale End
155Harb
156Harswell Dandy
157Hasna
158Hastily
159Hatadora
160Hearitfortheboys
161Heavenly Being
162Hector
163Helter Skelter
164High Order
165Hot Front
166Hurtle Wallop
167Idle Assembly
168Improvista
169Incan Empire
170Invincible Navy
171Iris Dancer
172Jack Of Clubs
173Jean Baptiste
174Jersey Rocs
175Jon Riggens
176Judgementofsolomon
177Judicial Reward
178Jungle Run
179Kalganov
180Kangaroo
181Kehlani
182Kento
183Kessaar Power
184Khamsin
185Kingkeer
186Kipp Kelly
187Kissininthebackrow
188Kitbag
189Knockmore Prince
190Kodebreaker
191Lady Bancroft
192Lady Invictus
193Laudable
194Laugh A Minute
195Lawmans Blis
196Leap Year Lad
197Level Up
198Liam Swagger
199Light Up Our Stars
200Lilla Cross
201Lillistar
202Liosa
203Lisabetta
204Lisamaria
205Little Queenie
206Little Siskin
207Lively Set
208Loving Look
209Lyric
210Madame Christine
211Makalu
212Make Clear
213Man Of Monaco
214Man Of Riddles
215Maries Jewel
216Marry The Night
217Marty The Party
218Mary Of Modena
219Masham Moor
220Master Builder
221Master Garvey
222Master Toney
223Match Anthem
224Mayo County
225Meet Me In Meraki
226Miami Hills
227Miaswell
228Mickey The Steel
229Miss Moonshine
230Mister Coco Fizz
231Molinari
232Morcar
233More Profit
234More Thunder
235Moss Tucker
236Motasaleeta
237Moutarde
238Mr Zippi
239Mrembo
240My Birthday Girl
241My Clementine
242Mystic Rose
243Mythical Guest
244Naasma
245Naisiun
246Nariko
247Nemov
248Nina Rapida
249Nordic Glory
250Notion In Motion
251Numidia
252Ocean Quest
253Oitentinha
254Old ****
255Olympic Quest
256Opec
257Orchidaceae
258Ower Starlight
259Parikarma
260Pastoral Way
261Percy Willis
262Perfect Curves
263Perianth
264Peruvian Sunset
265Philos
266Phoenix Fire
267Physique
268Pierrefonds
269Pinpoint
270Pique
271Play It Again Zaam
272Polar Bear
273Porfin
274Port Louis
275Postponed Legacy
276Powerful Response
277Pro Bono Alexander
278Purple Sky
279Purring Along
280Racing Vicar
281Rainbow Sign
282Rajeteriat
283Realt Na Ri
284Rebel Redemption
285Red Dwarf
286Red Veil
287Renoir
288Revenue
289Rock N Roll Pinkie
290Roll It In Glitter
291Rosy Affair
292Safari Dream
293Sapristi
294Sarahs Verse
295See My Baby Jive
296Selectivity
297Shalfa
298Shes Smart
299Showboated
300Sidneys Son
301Sighter
302Silastar
303Silver Gunn
304Simply Red
305Sing A New Song
306Sir Bolton
307Sir Geoff Hurst
308Skontonovski
309Smalleytime
310Smart Charger
311Sneaky Blinder
312Snellen
313So Farhh So Good
314So Majestic
315So Messi
316So Smart
317Something Nice
318Soowaih
319Sound Move
320South Dakota Sioux
321Spanish Flame
322Sparkling Sea
323Specialist View
324Split The Profit
325Spring Chorus
326Stag Night
327Stand Free
328Star Of St James
329Star Pupil
330Starliner
331Stella Alpina
332Steps In The Sand
333Still Standing
334Storm Call
335Stormy Jenn
336Streak Lightning
337Streetstorm
338Strike Rate
339Sugar Hill
340Summer Snow
341Surrey Belle
342Tafsir
343Tai Tam Bay
344Talking Rubbish
345Thaki
346Thatwilldoso
347The Amazon
348The Highway Rat
349The Man
350The Navigator
351The Whipmaster
352Thunderous Love
353Time Out
354Tip Top Tank
355Tomahawk King
356Toosha
357Torvar
358Tough Talk
359Tranquillitatis
360Transcending
361Trufonic
362Twenty Bob
363Twilight Jazz
364Twilight Jet
365Two B Tanned
366Two Past Eight
367Valentino Express
368Van Zant
369Velvet And Vine
370Velvet Skies
371Venus Slipper
372Verhoyen
373Villazon
374Viva Voce
375Volatile Analyst
376Wafei
377Wayne R Walker
378White Umbrella
379William Dewhirst
380Wood Farm Wag
381Xquise
382Yiengaa
383Young Endless
384Zabeel Road
385Zaphea
386Zharova
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A:BCell ValueduplicatestextNO
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
not sure what you are after here
But some of the entries have a SPACE after like
"Churchella "
in column B
so wont be seen as a dupicate as column A "Churchella" does not not have a space at the end and so NOT a duplicate

you may need to clean up the data - Or use a formula in conditional fromatting which has TRIM()

But not 100% sure what you are after - just testing for duplicates in column B ? that match A or comparing both B & A

also what version of excel are you applying to - Now a lot of difference between version 2021 and version 2016, considerably more functions making things much easier in 2021

worth just having in 1 version in profile as to match the version you need to use any solutions in
 
Upvote 0
not sure what you are after here
But some of the entries have a SPACE after like
"Churchella "
in column B
so wont be seen as a dupicate as column A "Churchella" does not not have a space at the end and so NOT a duplicate

you may need to clean up the data - Or use a formula in conditional fromatting which has TRIM()

But not 100% sure what you are after - just testing for duplicates in column B ? that match A or comparing both B & A

also what version of excel are you applying to - Now a lot of difference between version 2021 and version 2016, considerably more functions making things much easier in 2021

worth just having in 1 version in profile as to match the version you need to use any solutions in
Ah, I did not realise there was a space after some names as they come from different sources. Thank you.
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top