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"""]
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"""]
Last edited: