Colour row if cell value is met

[sharky12345]

I'm struggling with this and can't seem to find anything that does what I need. I want to achieve this by VBA and not conditional formatting - If the value of the cell in range E9:E6999 is 'Team' or 'Campaign' then I want THAT ROW from A:R only to be filled yellow, and no fill if not. I can't seem to find anything that does only that range, I've found plenty that fill the entire row but that's not what I want. I need this to run ideally on a command button within a userform but that's not essential if it can't be done.

 

[Andrew Poulsom]

Try eg:

.Parent.Borders(xlEdgeLeft).LineStyle = xlContinuous

 

[sharky12345]

That's done it - many thanks