A
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.
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.