Sir, Ma'am

I need a little help, ok lots of help. I can do basic formulas in excel,
but the more complicated ones throw me. I don't know the formula
codes/characters.

How would I go about changing the color of a formula total. I have tried
conditional formatting, got the numbers and cell to turn red, but I
couldn't get it to work with the formula. It is set up for subtraction
between one constant number (Insp due time) and one fluctuating number
(ECOT)....=SUM(D3-A4). What I am trying to do is have it change to Blue when
it gets to 20% time remaining, then Red when it gets to 15% time remaining. I
included the setup as I have it in excel. It starts on A1 and ends on E11.

A0378 Isp Time
E9173 JST Freq Due Remaining
ECOT 0041 800 Hrs 1996.0 547.6
1448.4 1052 100 Hrs No JST #VALUE!
1056 150 Hrs 1496.0 47.6
1058 50 Hrs No JST #VALUE!
1067 25 Hrs No JST #VALUE!
1069 200 Hrs 1496.0 47.6
1070 300 Hrs 1496.0 47.6
1085 100 Hrs 1472.1 23.7

Any help would greatly be appreciated.

V/R Martin

Opps,

It ends on E10.

V/R
Martin

"Martin" wrote:

Sir, Ma'am

I need a little help, ok lots of help. I can do basic formulas in excel,
but the more complicated ones throw me. I don't know the formula
codes/characters.

How would I go about changing the color of a formula total. I have tried
conditional formatting, got the numbers and cell to turn red, but I
couldn't get it to work with the formula. It is set up for subtraction
between one constant number (Insp due time) and one fluctuating number
(ECOT)....=SUM(D3-A4). What I am trying to do is have it change to Blue when
it gets to 20% time remaining, then Red when it gets to 15% time remaining. I
included the setup as I have it in excel. It starts on A1 and ends on E11.

A0378 Isp Time
E9173 JST Freq Due Remaining
ECOT 0041 800 Hrs 1996.0 547.6
1448.4 1052 100 Hrs No JST #VALUE!
1056 150 Hrs 1496.0 47.6
1058 50 Hrs No JST #VALUE!
1067 25 Hrs No JST #VALUE!
1069 200 Hrs 1496.0 47.6
1070 300 Hrs 1496.0 47.6
1085 100 Hrs 1472.1 23.7

Any help would greatly be appreciated.

V/R Martin

Figured it out. I just needed another cup of coffee.

Code was =$Col$Row<

Thanks all who were looking at it and trying to figure out what I was trying
to do.

V/R
Martin