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.

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 wrote:
>
> 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

On Mar 14, 10:30 am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> 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 wrote:
>
> > 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
Works great! Thanks

> > current cell is not.
>
> > Tried a few formulas without success.
>
> > =SUM(A1:CELL("address")) > 90
>
> > Any help would be appreciated.
>
> --
>
> Dave Peterson- Hide quoted text -
>
> - Show quoted text -