highlight row(s) based on value and the highlight row

[Trevor3007]

hi,

I tried conditional formatting but was not suitable (user complained).

can anyone supply me with the VB so if a a cell in row B, contains the word 'not open' it will highlight the row in yellow ?

the range of the worksheet is from a3:s9000...

many thanks in advance.

KR
Trevor3007

 

[Trevor3007]

you sir are a genius...

works a treat.

thanks DA... I also have another 'help' but will have to make a new ASK.

FANTASTIC!!!

Trevor3007

 

[DanteAmor]

I'm glad to help you. I appreciate your kind comments.

 

[Trevor3007]

justly deservered !! have posted another BTW