Vba to fill in row colour by cell value taking colour from a grath (range)

[tonywatsonhelp]

Hi Everyone,

I'm trying to create a list of customers and how long they have been waiting then colour code then green to red
What I was thinking is to create a graph area where i put my criteria and have vba macro look at each row in the list and colour code the list according to the rules in the graph, but I'd like it flexible in the number of options if possible?

So for example. lets say my list is H30:K30 and Column K has values in it (the amounts will vary but will start at no lower than 1)

So Column K has lots of numbers

theres a graph or grid area where i have the critiriea

Say Column A is the start number, B is the Fin Number and C is the colour?

Like This

	A	B	C
	From	To	Colour
	1	3	This cell is filled with a colour eg. Green
	4	6	so the colour of the cell is the colour to choose
	7	12
	12	above?	I'm not sure how many rows i'd like so if we could make this flexable then great, I put above but happy to set this up as you need it.

So hopefully this is clear but it a macro that looks at the number in column K find that number in the above area and makes the rows that colour

thanks
Tony