![]() |
|
#1
|
|||
|
|||
![]()
Please help me out ...
here I am attaching snapshots of two excel sheets 1. has description 2. names of persons What I wanna do is that , I want to check the names of person are matching should indicate me in red or whatever color in different cell from description list. If name is already in the list of "names list" file matching from the list of "names description" file should show me the indication that name is already in the list. Thanks waiting for snappy response. ![]() ![]() |
#2
|
||||
|
||||
![]()
Try conditional format formula starting at A2 of KYC Info sheet:
=COUNTIF(Sheet1!A:A,"*"&A2&"*") |
#3
|
|||
|
|||
![]()
Thanks alot for this.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
Searching for string on a formula | AMD2800 | Excel | 1 | 12-17-2014 10:41 AM |
![]() |
bob999999 | Excel | 1 | 04-28-2013 11:21 AM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
![]() |
OTPM | Excel | 5 | 05-17-2011 09:17 AM |