hightlight row(s) based on value

[Trevor3007]

Hi,

Does any have the 'VB knowhow' to highlight a row(s) that contain a certain value?

The range is c2:c200 & if it contains any of the following keywords:-

base test completed OK - light green\bold

base test completed failure - Light red\bold

base test on test - light yellow\bold

thank you 'kind person' & i look forward to your reply.

KR
Trevor 3007

 

[Rick Rothstein]

hi Rick,

try this via
https://1drv.ms/x/s!AvGGXsEtXRpdhLQHyELCe4_vqrpnMA

I think the problem is my code is conflicting with the Change event code mumps gave youi. When I comment out his portion of your Change event, my code seems to run fine. I can try to modify my code to replace mumps code inside your Change event procedure if you want, but I am thinking if mumps code is doing exactly what you want, maybe you should just stay with it and leave well enough alone.

 

[Trevor3007]

I think the problem is my code is conflicting with the Change event code mumps gave youi. When I comment out his portion of your Change event, my code seems to run fine. I can try to modify my code to replace mumps code inside your Change event procedure if you want, but I am thinking if mumps code is doing exactly what you want, maybe you should just stay with it and leave well enough alone.

Greetings Rick from across the pond,

thanks for your response. I would welcome your code and see what the results bring. I do find that the code I am using runs a tad slow, so if you can send me yours or speed up what I sent to you that will be good.

KR & MTIA
Trevor3007