Have You Tried Conditional Formatting

Its in Format Conditional Formatting...

You can set the background colour of a cell/row based on a cells
value.

You could do a condition for every colour you wouldn't need the colour
table.

Hope That Helps


--
Nigel_hough
------------------------------------------------------------------------
Nigel_hough's Profile: http://www.excelforum.com/member.php...o&userid=20623
View this thread: http://www.excelforum.com/showthread...hreadid=394263