LinkBack URL
About LinkBacks
Hi I have a simple question: how can I mark the cell with the name that can be found in another column automatically? Thanks.
Hi I have a simple question: how can I mark the cell with the name that can be found in another column automatically? Thanks.
If the cell is A1 and the name is in B1, then this in A1:
=B1
Or do you mean something else? Your request is not very detailed.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I have to agree with Ali. It isn't very detailed.
Here's another guess. Use conditional formatting like in the attached.
In with these two lists in columns A and B ...
... set conditional formatting Applies to: =$B$1:$B$14
Then click "New rule" > "Use formula to determine which cells to format" and use this formula ... for example.
Formula:
=MATCH(B1,$A$1:$A$14,0)
Dave
Hi Dave, this is exactly what I want. Thanks so much! You are smart :-). I did try Vlookup in conditional format but I couldn't get it done (Match works). Sorry Ali I didn't know how to attach a file or pict as Dave did here. Thank you too~ I have another question. If I want to delete the third row but I want to keep "Mike" (protect the whole columnA from deleting). How can I achieve this? Thanks.
This is a completely different query. Please start a new thread with an appropriate title.
Regarding attachments, unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
This thread should be marked as SOLVED using the Thread Tools link above.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks