I concur with rpeare on not quite following what you are trying to describe. Some specifics would likely be helpful. However, I did just implement something similar to what I think you are getting at. I will show you my code below
I have a report that gets exported to Excel for distribution. One of the columns in the report is High Priority which has either TRUE or FALSE values. The following code shows how I find the right column and highlight those rows
Code:
Dim lRow As Integer, lCol As Integer, i As Integer, HPriCol As Integer
lRow = xlWs.Range("A3").End(xlDown).Row
lCol = xlWs.Range("A3").End(xlToRight).Column
HPriCol = xlWs.Range("A3:" & A(lCol) & "3").Find("High Priority", , xlValues).Column
For i = 4 To lRow
If xlWs.Range(A(HPriCol) & i).value = "TRUE" Then
With xlWs.Range("A" & i & ":" & A(lCol) & i).Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
End With
End If
Next i
I hope that helps get you started.