Conditional Formating - Exceeds Cutoff

[aww91]

Trying to use conditional formating to change the font to red of any
cell that exceeds the cutout point.

Example
Column A:
1. 20
2. 30
3. 40
4. 10
5. 25
6. 20

The conditional format formula for A4 should sum A1:A4, if it exceeds
90 than change font to red (A5, and A6 would also change to red based
on their conditional formulas). While A1 will remain fixed, the
current cell is not.

Tried a few formulas without success.

=SUM(A1:CELL("address")) > 90

Any help would be appreciated.

 

[Dave Peterson]

Select all the cells in the range

With A1 the activecell
format|cells|conditional formatting
formula is:
=SUM($A$1:$A1)>90

The $a$1 says to always start with A1.
Excel will adjust the $A1 when it "copies" this formula to the other cells in
the selection.

 

[aww91]

Select all the cells in the range

With A1 the activecell
format|cells|conditional formatting
formula is:
=SUM($A$1:$A1)>90

The $a$1 says to always start with A1.
Excel will adjust the $A1 when it "copies" this formula to the other cells in
the selection.

Works great! Thanks