Conditional Formatting

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top