Permanent Highlight using Conditional Formatting

[BenNV]

I have a value in D1 (which is constantly/automatically changing), If this value in D1 matches, say, E5, then I want the row to change colour to Orange, permanently.

Because D1 is changing, the cell does not seem to stay highlighted - is there anyway round this.

Also, I would like the whole row (from A5 to L5) to be highlighted, but this does not seem to work, eventhough I select all rows when setting the conditional format.

 

[BenNV]

Works perfectly, thank you Dave/Tom. Much appreciated.

 

[Dave Hawley]

Ben, it's a pleasure to help someone that takes the time to say thanks.