How to highlight an entire row if a row is a specific value

[phkc070408]

I'm looking for a VBA code that:

In the worksheet named "Queensland, " If any cell in the range A1 to A50 contains "Cairns," Shade the entire row from column A to the last used column.

I recorded this macro to get the color of the shade that I want, but I'd like to auto-select it by the value in column A.

Please Login or Register  to view this content.

[k1dr0ck]

try

Please Login or Register  to view this content.

[phkc070408]

Nice - TYVM!!!