Auto change background of color based on formula

[Guest]

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

 

[Guest]

Check on conditional formatting, particularly the formula portion then post
questions from there.

 

[Guest]

Select your range

Condition 1 =A4>A9
Format cell green

Condition 2 =A4<A9
Format cell red

 

[Gord Dibben]

Select A4 and A7 and any others you need.

Format>Conditional Formatting>Condition1>Cell Value is:

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

Add>Condition2>Cell 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