Based on an calculated "average" I want to change the color of cells based on
"over" or "under" the average.

ie.
Average in cell A9 is 8
Value in cell A7 is 5
Value in cell A4 is 11
Color of cell A7 to be red and color of cell A4 to be green

Thanks in advance