Is there a way to have more than 3 conditional statements (excel 2003). I
need to add another one but I'm not sure how to do it.

Here's what I have right now:

Columns("P:Q").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""10%Late - 10%Ahead""", Formula2:="=""10%Under-10%Over"""
Selection.FormatConditions(1).Interior.ColorIndex = 4
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""11%-20% Late""", Formula2:="=""11%-20% Over"""
Selection.FormatConditions(2).Interior.ColorIndex = 6
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""More than 20% Late""", Formula2:="=""More than 20%
Over"""
Selection.FormatConditions(3).Interior.ColorIndex = 3
Cells.Select

If anyone can help me with this, that would be great!

Nope. xl2003 only supports 3 of those conditional formatting rules--just like
you see in the user interface. (xl2007 has lots more, fyi.)

Bob Phillips has an addin that you may like:
http://www.xldynamic.com/source/xld.....Download.html

Patty wrote:

Is there a way to have more than 3 conditional statements (excel 2003). I
need to add another one but I'm not sure how to do it.

Here's what I have right now:

Columns("P:Q").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""10%Late - 10%Ahead""", Formula2:="=""10%Under-10%Over"""
Selection.FormatConditions(1).Interior.ColorIndex = 4
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""11%-20% Late""", Formula2:="=""11%-20% Over"""
Selection.FormatConditions(2).Interior.ColorIndex = 6
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""More than 20% Late""", Formula2:="=""More than 20%
Over"""
Selection.FormatConditions(3).Interior.ColorIndex = 3
Cells.Select

If anyone can help me with this, that would be great!

--

Dave Peterson

thanks!

"Dave Peterson" wrote:

Nope. xl2003 only supports 3 of those conditional formatting rules--just like
you see in the user interface. (xl2007 has lots more, fyi.)

Bob Phillips has an addin that you may like:
http://www.xldynamic.com/source/xld.....Download.html

Patty wrote:

Is there a way to have more than 3 conditional statements (excel 2003). I
need to add another one but I'm not sure how to do it.

Here's what I have right now:

Columns("P:Q").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""10%Late - 10%Ahead""", Formula2:="=""10%Under-10%Over"""
Selection.FormatConditions(1).Interior.ColorIndex = 4
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""11%-20% Late""", Formula2:="=""11%-20% Over"""
Selection.FormatConditions(2).Interior.ColorIndex = 6
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=""More than 20% Late""", Formula2:="=""More than 20%
Over"""
Selection.FormatConditions(3).Interior.ColorIndex = 3
Cells.Select

If anyone can help me with this, that would be great!

--

Dave Peterson