highlight/remove highlight of rows conditional on cellvalue

Hey there,

What I wish to acheive by this macro is that all rows with value in column B being the same as the chosen value from a dropdown list (in d2) are highlightet, when the macro is run. Also, when d2 is empty and the macro is run, I want the (by the macro) previously highlightet rows to go back to normal (not highlightet). Hope that makes sense The code below (not working) shows what I got at this point.
I also considered making it a Worksheet_Change event instead, but i guessed this would make it more demanding than a sub to run by click on a commandbutton. Is that right?

Thanks a lot in advance for your help.

Please Login or Register  to view this content.

Excellent! Problem solved. Thanks a lot