Asslaam o Alaikum
aik excel ki file attached kr raha hoon, isko dekh kr formula sy update krdain, file me hy meny requirement likh de hy, main Excel 2016 use krta hoon agr phir bhi kuch pochna hotu please zaroor pochlijiyega... Jazak Allah
Asslaam o Alaikum
aik excel ki file attached kr raha hoon, isko dekh kr formula sy update krdain, file me hy meny requirement likh de hy, main Excel 2016 use krta hoon agr phir bhi kuch pochna hotu please zaroor pochlijiyega... Jazak Allah
King Khan bhai apka Bohat Bohat Shukria, bus aik issue rehgaya hy wo conditional formating ka hy, apky formula ko conditional formating me apply kia to hightlight duplicate names, but it does not work properly, file attached ki hy, please please resolved this issue.... Jazaak Allah
Syar bhai apka formula bohat effective or simply hy
bus aik issue rehgaya hy wo conditional formating ka hy, apky formula ko conditional formating me apply kia to hightlight duplicate names, but it does not work properly, file attached ki hy, please please resolved this issue.... Jazaak Allah
Please try:
Remove all conditional rules from range and
select your range, conditional formatting-->Manager Rules---> New rules and copy this formula, as per your sample sheet formula will work otherwise change ranges and references
Code:=COUNTIF($B$2:$B$31,"*"&B2&"*")>1
Bookmarks