Formula error

[VbaHell]

Hello all

I am having a Compile error with the VBA code below on the formula below


[With Range("$A$8:$B$100")
.Select
.FormatConditions.Add Type:=xlExpression, Formula1:"=J$8=""Closed"""
.FormatConditions(.FormatConditions.Count).Interior.ColorIndex = 4
End With]

Can anyone tell me my stupid mistake please


sorry now found my error

[.FormatConditions.Add Type:=xlExpression, Formula1:="=$J8=""Closed"""]

 

[rlv01]

I notice you did not include the specific compiler error message in your post. What was it?

 

[VbaHell]

I notice you did not include the specific compiler error message in your post. What was it?

solved the issue now. thanks