D delta Member Feb 23, 2014 #1 i use office 2007 in column "A" contain name is rashesh kalpesh vipul hitesh chirag viral balu mihir golu and column "B" contain name is mihir vipul kalpesh viral golu now i want to same name in both column is highlight how it is done pls help urgently what is formula
i use office 2007 in column "A" contain name is rashesh kalpesh vipul hitesh chirag viral balu mihir golu and column "B" contain name is mihir vipul kalpesh viral golu now i want to same name in both column is highlight how it is done pls help urgently what is formula
Smallman Excel Ninja Feb 23, 2014 #2 Hi Delta In Col A put this formula as a Conditional Formatting Rule. =COUNTIF($B$2:$B$8,A2)>0 In Col B put the opposite. I will attach a file to show workings. Take care Smallman Attachments CondF.xlsx CondF.xlsx 9 KB · Views: 2
Hi Delta In Col A put this formula as a Conditional Formatting Rule. =COUNTIF($B$2:$B$8,A2)>0 In Col B put the opposite. I will attach a file to show workings. Take care Smallman
