conditional formating

[Gail]

Is there another option for conditional formatting since
it is limited to only 3 conditions for each cell - I need
to assign about 8 conditons to a series of cells. I am
only looking for the cells to change color.
Basically I want the cell to change color if a certain
word is typed in that cell.Any suggestions.

I am using Excel 2002. I thought I might be able to use a
macro but am very new to that feature and don't even know
where to start. Any suggestion would be great

 

[Paul B]

Gail, you could use a macro like this, put in sheet code

Private Sub Worksheet_Change(ByVal Target As Range)
For Each c In Range("a2:a25")
If c.Value = "a" Then c.Interior.ColorIndex = 1
If c.Value = "b" Then c.Interior.ColorIndex = 13
If c.Value = "c" Then c.Interior.ColorIndex = 3
If c.Value = "d" Then c.Interior.ColorIndex = 4
If c.Value = "e" Then c.Interior.ColorIndex = 5
If c.Value = "f" Then c.Interior.ColorIndex = 6
If c.Value = "g" Then c.Interior.ColorIndex = 7
If c.Value = "h" Then c.Interior.ColorIndex = 8
If c.Value = "i" Then c.Interior.ColorIndex = 9
If c.Value = "j" Then c.Interior.ColorIndex = 10
If c.Value = "k" Then c.Interior.ColorIndex = 11
If c.Value = "l" Then c.Interior.ColorIndex = 12
Next c
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **