condition format - greater than and lower than

[VbaHell]

Hello all

Can you help on this please as I have brain freeze

I want this VBA line of code to say = "=$F10 >4 but <8

[With Range("$F$10:F" & LR)
.Select
.FormatConditions.Add Type:=xlExpression, Formula1:="=$F10>6"
.FormatConditions(.FormatConditions.Count).Interior.Color = RGB(153, 255, 102)
End With]

 

[Joe4]

Change this line:

.FormatConditions.Add Type:=xlExpression, Formula1:="=$F10>6"

to this:

.FormatConditions.Add Type:=xlExpression, Formula1:="=AND($F10>4,$F10<8)"

 

[VbaHell]

Change this line:

.FormatConditions.Add Type:=xlExpression, Formula1:="=$F10>6"

to this:

.FormatConditions.Add Type:=xlExpression, Formula1:="=AND($F10>4,$F10<8)"

that's great, thank you very much

 

[Joe4]

You are welcome.