chalo shukr hi hamari b entry hogai forum me koch saloun baad.
chalo shukr hi hamari b entry hogai forum me koch saloun baad.
Sir, Aap hukum karian mein Hazir Hoon..
Is mein aik masla bhi hay ke yeh sari entries ko colour kardeta hay, mera khyal hay wo sirf jo duplicate entries hain un ko hi colour hona chaheye tha....
Baqi aap ki maddad ka bohat bohat shukria...
Fees wal masla ap btaye mein hazir hoon..
:
بہت بہت شکریہ سر۔۔
میں نے پی ایم کردیا ہے۔۔۔
please share your formula and screenshot of the conditional formatting rule you have define
and when you define rule which cell you have selected
OK Sir,
Bohat Bohat shukria, screen shorts attach kar dye hain...
1. to clear all conditional rule go to conditional format---> Clear Rules---> and clear rules from entire sheets
2. go to conditional formatting--->new rule--> define formula--> and apply the below formula.
and apply the condition.Code:=SUMPRODUCT(--ISNUMBER(SEARCH($D$1:$D$5, A1))) > 0
Please clearfully define the ranges, if range in wild search is blank it will highlight the cell
you may change search with find for exact match.
regards,
میں چیک کرکے جواب دیتا ہوں۔۔
فیس والی بات بیچ مےہی رہ گئی ہے۔۔۔
باقی آپ کے ساتھ بہت لوگوں کی دعایئں ہیں جنکی آپ نے فی سبیل اللہ مدد کی ہے۔۔
He(syar) is a nice and knowledgeable man(boy) especially in the field of Excel.
Bookmarks