|
Posted to microsoft.public.excel.programming
|
|
|
Conditional Formatting
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
|