condition formating with VBA

[VbaHell]

Hello MrExcel world

I need help please on this statement for condition formating
I want to only format the row from A:C.& G:J if the value in J is "Open" but it's formating row's D,E,F as well

[
LR = Range("B" & Rows.Count).End(xlUp).Row

With Range("$A$8:C" & LR, "$G$8:J" & LR)
.Select
.FormatConditions.Add Type:=xlExpression, Formula1:="=$J8=""Open"""
.FormatConditions(.FormatConditions.Count).Interior.Color = RGB(255, 100, 100)
End With]

Any help would be great please

 

[dmt32]

Hi,
try changing this line

With Range("$A$8:C" & LR, "$G$8:J" & LR)

to this

With Range("$A$8:C" & LR & "," & "$G$8:J" & LR)

and see if resolves your issue

Dave

 

[VbaHell]

Hi,
try changing this line

With Range("$A$8:C" & LR, "$G$8:J" & LR)

to this

With Range("$A$8:C" & LR & "," & "$G$8:J" & LR)

and see if resolves your issue

Dave

Dave that works great, thank you very much

 

[dmt32]

Dave that works great, thank you very much

glad resolved & appreciate feedback

Dave