Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Mark a cell adjecent to another cell baced on a lokkup

More
3 months 3 days ago #1306 by Kevin
Column A is a list of unique numbers
I want to look in Column A based on the contents of Cell D2 (The value in D2 changes with each lookup)
When a match is found in Column A I want to change the cell background color to Green
The Cell found in A that matches D2 needs to remain green with successive lookups
Eventually all cells may be Green, those that are not, are not found

Any help would be greatly appreciated.
Attachments:

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo