Auto Hightlight Entire Row - only when active cell is on specific columns

I want the entire row auto highlighted, only when I press any cell in columns: A, C, I, K, Q, S, T, U, V, W, X, Y, Z, AA.

thank you

I have also posted this question at these sites:
http://www.ozgrid.com/forum/showthre...407#post735407

Thank you for supplying the link to the other forum as per forum rules. This code will go into the Visual Basic Editor under the applicable sheet code

Please Login or Register  to view this content.

this is perfect thank you. Is there a way to change the highlight colour?

i found this code on the internet and like the colour, how can i use with your code?
-------------------------------------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Cells.FormatConditions.Delete
Target.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
Target.FormatConditions(1).Interior.ColorIndex = 24

End Sub
-----------------------------------------------------------------------------------------

Please Login or Register  to view this content.

the first one worked but this code leaves behind the highlighted rows?

how can i also change the code so that instead of the entire row being highlighted - only columns B to R are highlighted (that's the row from B to R)

thanks