Column Comparison Urgentttt

[Bibhuti1]

I need a formula takes unique values of column A(that means no similar values in column A) and highlight the cell it if a unique value exist in column B.
Ex:
A B
11 84
22 56
33 11
44 22
55 22
44 33
66 44
Like in the above example 11 and 33 got highlighted but not 22 and 44.
here I have highlighted font colour but I need cell to be highlighed.

I have a formula " =countif($B:$B, $A1) ""

but it highlights 22 and 44.

[Glenn Kennedy]

Use this for your Conditional Formatting.

ISNUMBER(MATCH(A1,$B$1:$B$7,0))

You really should avoid using phrases like "Urgent" in your title. It can get people annoyed - why is your problem any more important than anyone else's??? We do this for fun and don't get paid for it and don't respond well to these phrases.

[FDibbins]

Especially with all those extra "t"s in there, makes you sound like a kid lol

[Glenn Kennedy]

I'm not gowing to complane aboot onyoone else's spooling.... Especially when my posts made in the morning, when at home are often made in a very dark room....