Lookup and highlight matched cell with colours

  • Thread starter Thread starter Mindee
  • Start date Start date
Mindee,

I tested it and it worked for me. Is it wrap-around? The following code

Case Evaluate("=NOT(ISERROR(MATCH(" & .Value &
",A4:J4,0)))")
.Interior.ColorIndex = 4 'yellowblue
Case Evaluate("=NOT(ISERROR(MATCH(" & .Value &
",A5:J5,0)))")

should be just 3 lines, that is the ",A5:J5,0)))") code should be at the end
of the previous lien. It will show up (in red?) until it is correct.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Yupee Yupee!!! Thank you Bob , I got it!

But one more question to go. How do i stop the hassle of manua
runnning the macros. Is there a way whereby when matching figures ar
key in, it will auto highlight. rather than manual running it.
As some of my team mates might not know how to run it and end u
messing up those codes.

I am really rejoice! Thank you Guys!
You guys are great!!! Yupee!

Mindee:
 
Hi Bob,
So far your code works well other than the hassle.
How do i stop the hassle of manual runnning the macros. Is there a way
whereby when matching figures are key in, it will auto highlight.
Rather than manual running it.
As some of my team mates might not know how to run it and end up
messing up those codes.

Where can i find those colour codes?

mindee
 
Hi Guys,

Bob has help me alot and given me a marcos code. It works well at th
beginning.
But i realise i have to manual run the code everytime values are ke
in. (especially if values are deleted irrelevant colour cells ar
still there.) And everytime i need a brand new worksheets, i will nee
to copy and paste the code, and manually run it later.

How do I solve the manually running problems and as well as copying an
pasting problems.(As i am afraid i might lost/deleted those code
accidentally one day)

Thank you!


Minde
 
Hi Mindee,

Sorry I have been away so not able to respond.

Yes it can be automatic when updated, that was my original response that did
that. Check back on to that message.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top