Conditional Format - More than three

[Moxioron]

Hello all.

I am trying to figure out how to apply conditional formatting with more than three conditions.

I need the cell to change color based on the following options

Open
Closed
Re-opened
Pending
Escalated

Is there a formula to accomplish this? Thanks for your help.

 

[Yahya]

in excel2003 you need code to do it

 

[3link]

Hello all.

I am trying to figure out how to apply conditional formatting with more than three conditions.

I need the cell to change color based on the following options

Open
Closed
Re-opened
Pending
Escalated

Is there a formula to accomplish this? Thanks for your help.

Yes. Are you applying this to a single column?

Edit: As Yahya said, you wouldn't be able to do it without code in excel 2003. I think that version only allows up to 3 conditions per cell.

 

[Moxioron]

Can you build code without Visual Studio in Excel? Thanks.

 

[Yahya]

you need to use this code

Sub CF()
Dim LR As Long, c As Range
LR = Range("A" & Rows.Count).End(xlUp).Row
For Each c In Range("A1:A" & LR)
    Select Case c.Value
        Case "Open"
            c.Interior.ColorIndex = 2
        Case "Closed"
            c.Interior.ColorIndex = 3
        Case "Re-opened"
            c.Interior.ColorIndex = 4
        Case "Pending"
            c.Interior.ColorIndex = 5
        Case "Escalated"
            c.Interior.ColorIndex = 6
        Case Else
            c.Interior.ColorIndex = 7
    End Select
Next c
End Sub

 

[Peter_SSs]

If you want to make it more dynamic, like traditional Conditional Formatting, you can use code similar to Yahya's but linking it to the Worksheet_Change event. Here's an example with explanation of how to implement it:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90