Created validation drop-down list - can I make the row now change to the colour that

Hello,

I'm new to this forum and unfortunately not great with Excel and been given the task of putting together a a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.

For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange

etc.

Is this possible within Excel 2003? I did a search before posting and found that it may not be possible with 2003 to have more than 4 colours. Is this correct and is there a way around it?

Many thanks