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

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

Columns("A:R").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=And(Upper($C1)=""10000"",Upper($C1)<=""19999"") "
Selection.FormatConditions(1).Interior.ColorIndex = 38


--

"Crowbar via OfficeKB.com" <u15117@uwe wrote in message
news:588a9f6cd3357@uwe...
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

Toppers wrote:
Try:

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


This works for all cells in the columns formated. What I need is only the
data in column C but if column C needs to be formated differently so does the
whole row so I have one long pink line

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

Thanks Tom

That appears to work perfectly

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