Highlight Column When Specific Cells are selected

[SuperFantastic]

Hey everyone, here's what I'm trying to do. Whenever a cell in row 5 is selected, highlight the column in a specified range. I've used conditional formatting based on a formula, =COLUMN()=CELL("col"), and the following VBA code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.CutCopyMode = False Then
Application.Calculate
End If
End Sub

This highlights the correct cells, but it does so when any cell is selected on the sheet. I'd like to highlight the column, only when a cell in row 5 is selected.

Thanks!

 

[jasonb75]

See if changing the formula works

=(COLUMN()=CELL("col"))*(CELL("row")=5)

 

[SuperFantastic]

See if changing the formula works

=(COLUMN()=CELL("col"))*(CELL("row")=5)

Yes, that did it! Thanks!