Hi,
I am trying to conditionally format a range of cells depending on the content of a column that is not attached to the cells that will be conditionally formatted. The column I am using is "AQ' and if the cells are populated with a "D" then the corresponding cells in columns "A:C" should be formatted as bold red, if the cells include "N", then the formatting will be black. I can get it to work for the first cell, but it will not loop through the additional cells and do the formatting. I am including the code below. Please help! 


For counter = 1 To cCount
   Range("AQ2:AQ" & cCount).Select
    If Sheets("07 vs 08").Range("AQ2").Value = "D" Then
        Sheets("07 vs 08").Range("A2:C2").Font.Color = vbRed
        Sheets("07 vs 08").Range("A2:C2").Font.Bold = True
    Else
        Sheets("07 vs 08").Range("A2:C2").Font.Color = vbBlack
        Sheets("07 vs 08").Range("A2:C2").Font.Bold = False
    End If
    Next counter