Conditional Formatting & Data Validation Lists - Excel 2003

Hi,

I'm trying to put together a spreadsheet that will format the colour of a row based on a value in a data validation list.

The problem is that I am limited by excel 2003. It only allows 3 conditional formats. I need to have a selection of 5 - 8 colours for the different options in the data validation list in column F. If possible I also want to have a conditional format in place for column I. If "h" is selected then it overrides the conditional formatting directed in column F and turns the row a specific colour. Am I asking Excel 2003 to do too much?

I suspect that a VBA code might sort this out easily, but I know little about VBA. I already have a VBA date stamp code in this spreadsheet, so the VBA code will need to be added to and run alongside the existing code. I need something that is relatively people proof and will allow for the insertion of new rows of data within the spreadsheet and at the bottom of the spreadsheet.

Any help is much appreciated. I have attached my spreadsheet so far in excel 2003 format if it is any use.

Many Thanks In Advance,
Joel

Here is the spreadsheet attached.

Data validation Q. Cells in range E4:E10 are Data Validated. I would like to also have the cells custom validated so that no data can be entered if there is data missing in any of the cells in columns B through D in each of the respective rows. In other words, a custom validation along with a drop-down list. Possible?
Thanks in advance.