P
Patty
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!
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!