XL 2003: Can conditional formatting go past 4 conditions to N?

Hi

I have been asked to colour code a row within Excel 2003 based on a number between 1 and 9 in the first column.

Can you have more then 4 conditions in Excel 2003 i.e.
A1 = 1, cell is red
A1 = 2, cell is green
.
.
A1 = 9, cell is 9th different colour

If this is possible, can you conditionally format a range within the row i.e.

A1 = 1, then A1:A10 are red
A1 = 2, then A1:A10 are green

Hope you can help.

Chris

Not without using VBA

nope! 3 is the limit +its default colour. without code.
or you could try the cfplus addin http://www.xldynamic.com/source/xld.....Download.html