Try:

Selection.FormatConditions.Add Type:=xlExpression, Operator:=xlBetween, _
Formula1:="10000", Formula2:="19999"

"Crowbar via OfficeKB.com" wrote:

Hi there

I have this conditional format that highlights items that have a value of a
1000

Columns("A:R").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=UPPER($C1)=""1000"""
Selection.FormatConditions(1).Interior.ColorIndex = 38

I want to keep this syntax but instead of highlighting items that are a 1000,
I want it to hightlight items between values 10000 and 19999 i.e.

If the cell contained 12564, it would then do the highlight

Does anyone know how to ammend this?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1