Or Excel 2007, there are no limits (except hardware) on the number of
conditions for conditional formatting in 2007


--
Regards,

Peo Sjoblom



"Toppers" wrote in message
...
You will need VBA code (sample) below.

To enter, right click on worksheet tab, "View Code" and copy and paste
code
below.

You will to change the WS_RANGE to that of your Part #s and then extend
the
CASE statements..


-----------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
'-----------------------------------------------------------------
Const WS_RANGE As String = "H1:H10" '<=== change to suit


On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
Select Case .Value
Case 1: .Interior.ColorIndex = 3 'red
Case 2: .Interior.ColorIndex = 6 'yellow
Case 3: .Interior.ColorIndex = 5 'blue
Case 4: .Interior.ColorIndex = 10 'green
End Select
End With
End If

HTH

"BillO" wrote:

Simple help needed, I want to make a cell return a value when another
cell
has a particular value. for example

Part # color
11 red This cell = red, blue, . depending on what Part # is entered.
15 blue
23 violet
18 green
19 brown
21 black

Hope to hear back soon, thanks