Looping with an if statment

[seasmith]

I have dates in column L that have the conditional formatting of:

Cell Value <= Today()-365*(3*$N7:$N$368)-182

I need to loop thru every row in column L and see if the conditional formatting is true or not. I know C pretty well but am still farely new to VBA and arent quite sure how to do it. Any help would be great!

 

[Jonmo1]

There's no easy way to test if conditional formatting is true/false in a particular cell.

The trick is to test for the condition itself instead..


Hope that's helpfull.

 

[seasmith]

that is what I was planning on doing but I'm not quite sure how I would type those conditions into VBA code

 

[Marcelo Branco]

Maybe, if the range is constant, something like

    Dim i As Long
    
    For i = 7 To 368
        If Range("L" & i) <= (Date - 365 * (3 * Range("N" & i)) - 182) Then
            'Your code here
        End If
    Next i

M.