help meeeeeeeeeeeeeeeeeeeeeee plz

[LOVERS]

salam to all

main exel main conditional formating kuch is tarha karna chahta ho aur exel ka version 2010 use kar raha hon meray pas tamam version majood hain ap plz meri help karain main khud version jo ap btain gay instal kar lo ga....






kuch is tarha k column-a and column-b have same value then it will highlight when it will duplicate........
or
colum-a have same value in duplicate butt colum-b have diff value it will high light when record duplicate



WSLM::

[LOVERS]

[waqasmalik7]

ok bahi ap ya kran offic 2007 instal kran our baqe tmam satings man apny techer sy bta kr kal send kr donga ok

[LOVERS]

ap ka teacher shaid mujh say poch k jay \

[Asham Khan]

Cells Ko Select Karen Aur screen Shot dekhen

[LOVERS]

Bhai ye to duplicate k liay hay mujhay colum-a aur b ki value same hoon to highlight karna tha ap meri screen shot thek say dekhain

ye formating to main nay dekha di hay