Ineed some help with either a macro or VBA that would allow a table to be
populated with a set of numbers and based on those numbers the appropriate
cell would be shaded a specific color.

an example follows:

A B C D E
1 boat1 boat 2 boat 3 boat4 boat 5
2 1/1/06 10 14 23 9
3 1/7/06 2 16 3 1
4 1/14/06 3
5 1/21/06 4

the number range is 1 thru 30. currently there is only information in 24 of
the associated rows in a lookup table which links to a form style
spreadsheet. What i need to do is either randomly populate this table so that
the numbers are randomized down each column but are not duplicated across the
row or color code the cells based on the number entered from a predetermined
listing. 1 - 9 are one color, 10 - 12 is another, and so on. if more
information is needed just ask. you can also email me at
. if need be i can recreate it and send it.