Hi there
I have a macro that fomats columns in an active row. In column "R" I have a
formula that returns the value of 2 if the condition is true. I want to write
a macro that will find the 2(s) in column R and run my formating macro.

Heres my formatting macro
'Range("C" & ActiveCell.Row, ActiveCell.Offset(0, 10)).Select
'Let r = ActiveCell.Row
Range("C" & ActiveCell.Row & ":M" & ActiveCell.Row).Select
With Selection.Interior
.ColorIndex = 37
.Pattern = xlSolid
End With
Selection.Font.ColorIndex = 3
Selection.Font.Bold = True
Range("R" & ActiveCell.Row).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("H" & ActiveCell.Row).Select
Selection.ClearContents
Thanks for your time