This can, easily, be accomplished in Excel 2007 OR with a Macro.
Use Select Case segment in order to check the value [1-7] and accordingly
color the row.
Micky


"Peterepeat" wrote:

I have a table and in one column the user needs to add a number between 1-7
(inclusive) to show the status. Ideally I would then like the whole row to
be coloured, depending on the number inserted (eg. 1=Blue, 2=red, etc)

With the conditional formatting option within Excel I can only do 3 options.

How do I overcome this?