Hi all,
Is there a way to SET a range depending on font color ?
I jusy want to work with cells in the range with font color green.
What I got so far below. HELP!
Thanks,
[vba]
Set BigRange = Range("q1:q20").Font.ColorIndex = 4 ‘ this is the problem
If Range("D34").Value < 1 Then
For Each C In Range("BigRange ").Cells
If C.Value = WorksheetFunction.Small(Range("BigRange "), 1) Then
Cells(C.Row, C.Offset(, -13).Column).Value = "YES"
Range(C, C.Offset(, 13)).Font.ColorIndex = 3
Exit For
End If
Next C
End If
[/vba]