Conditional formatting (Colour Scales) across a range of cells

Gethin 

And here--I can be a nice guy too, and just answer your question--is an example of how you could create conditional formatting that highlights the Highest value (in green) and the Lowest (in red) in nine different cells across three rows.

I have a couple text boxes in the sheet that explain a little of the thinking. You'd have to adjust the formulas for calculating min and max to the cell references in your own sheet, but other than that it should work just fine. The heart of my way of doing it is to put two cells off to the side--call them "helper cells--finding the minimum of your nine in one of them; the max in another. And then use the value in those two cells as the determining factor in your conditional formatting rules.

But please do give thought to organizing your database itself differently so as to take advantage of Excel's amazing abilities to summarize that data.