Data validation?

Question

Is there anyway in excel 2003 to use more than 3 validation options. I need to use five and depending on whats entered have a cell chang colour. Its urgent but I need it to be simpel as I'm not very good at understanding what people mean all the time. Sorry.

SORRY ITS CONDITIONAL FORMATTING IM USING

I came across this on yahoo.
CODE BY Castalian Tourist
Sub ColorCoding()

Dim rngCell As Range

For Each rngCell In Selection

rngCell.Offset(0, 1).Interior.ColorIndex = xlNone

If IsNumeric(rngCell.Value) And Len(rngCell) > 0 Then
Select Case rngCell.Value
Case Is > 4
rngCell.Offset(0, 1).Interior.Color = vbBlue
Case 3 To 4
rngCell.Offset(0, 1).Interior.Color = vbRed
Case 2 To 3
rngCell.Offset(0, 1).Interior.Color = vbYellow
Case 0 To 2
rngCell.Offset(0, 1).Interior.Color = RGB(255, 140, 0)
End Select

End If

Next rngCell

End Sub

What I want to do is make the colour appear in same cell where the condition is met. also make it run automaticly, could anyone help me please

Answer 1

Not that I am aware of with the built-in conditional formatting.

You could write a VBA macro yourself or browse the net for one that's already been written (there are many Excel user forums where people will help out) .. here's a few I found later :-)

Answer 2

It IS possible but you would need to use VBA. Excel triggers an event when a cell is changed. A small piece of VBA code can work out which cell changed and then carry out the validation and set the colours accordingly.