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

Check on conditional formatting, particularly the formula portion then post
questions from there.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"fredwing" wrote:

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

Select your range

Condition 1 =A4A9
Format cell green

Condition 2 =A4<A9
Format cell red


"fredwing" wrote:

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

Select A4 and A7 and any others you need.

FormatConditional FormattingCondition1Cell Value is:

Less than.............=$A$9 Format to Green Pattern

AddCondition2Cell Value is:

Greater than...........$A$9 Format to Red.

Note the $ signs. They are mandatory to anchor A9 as the condition cell.


Gord Dibben MS Excel MVP


On Wed, 3 Jan 2007 16:00:00 -0800, fredwing
wrote:

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