Need Similar formula in Excel!

[hashibhai111]

Dear guys!
Muja koi hep kro ka excel sheet ka mai aik list bnata ho
suppose
1284
1285
1286
aur iska phir bad mujse galti sa 1284 dal jata ha
ab muja koi aisa formula batein ka dono jaga pa 1284 khud b khud highlight ho jaya
aur muja pata chal jaya ka maine konsa number duplicate dal diya ha
shukirya!

[farhanleos]

Dear friends excel k menu mai ek option hai conditional formatting ki us ki help se ap apne problem solve kar skte hai
karna ye hoga ap ko k ap pora column select karain or pher conditional formatting wale menu mai jain or wha Highlight Cell Rules mai ja k
Duplicate values par click kar k OK kar dain
pher ap us column mai ager duplicate amount type karai gay to wo light pink color mai highlight ho jae geeee
Ager abe b smj nae aye to mjepm karai mai ap ko further guide kar doo ga

[hashibhai111]

thxxxxxxxxxxxxxx prb solve lov u bro