OK, let me see if I can't explain what I'm trying to do without turning
your brain to swiss cheese. (Mine's already turned, lol)...

I'm working on a fuel log. (Check out the attachment)

In cells C5:H5 I've got formulas that average the data in their
respective columns.

In columns M thru V I've got formulas averaging things into two sets,
high and low. If any value is lower than the original average (row5) it
gets averaged into the "low" cell. same for "high"

Still with me?..

OK, you'll notice that cells C5:H5 have conditional formatting based on
the highs and lows.
If the "original" average (row5) is higher than the "high" average then
the text is green. If it's between the "high" and "low" then it's orange
and if it's lower than the "low" average it goes red...

I'm wanting to do away with the "high" and "low" cells and have the
conditional formatting formula take care of things.

Is this at all possible?

Let me know if you need me to make more sense of things...


+-------------------------------------------------------------------+
|Filename: MPG Explorer.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4268 |
+-------------------------------------------------------------------+

--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile: http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505215

Bump...

Anyone have any ideas?


--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile: http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505215

Anyone having any luck with this one?


--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile: http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505215

Hi!

I looked at your file. I think there is a flaw in your logic.

1. the avg will always be at least equal to or between the min avg and the
max avg.
2. the avg will never be higher than the max avg.
3. the avg will never be lower than the min avg.

Or am I not understanding what you want?

If the "original" average (row5) is higher than the "high" average then
the text is green. If it's between the "high" and "low" then it's orange
and if it's lower than the "low" average it goes red...

Biff

"S3NTYN3L" wrote in
message ...

Anyone having any luck with this one?


--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile:
http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505215

I think you are correct now that I look at things...

I'm trying to have the averages in row 5 color coded so that it's green
if it's risen and red if fallen. (Reverse that in the case of the dollar
amounts on the left).

Something just now hit me...

Would this be a TREND function I'm thinking of?

I'm also going to have each entry color coded based on if the data
entered is higher or lower than the overall average.

In a nutshell, I'm wanting to be able to see how well my vehicle
mileage is and "guage" (when things start turning red) when it's time
to change the oil, air & fuel filters, give it a tune up, etc.

I'm also wanting to get rid of the cells on the right ( M-V I believe).
I don't like having to hide those columns...


I hope I haven't confused you even more....


--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile: http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505215

Hi!

What you would have to do is compare the previous avg with the new avg. That
would require formulas to calculate both the previous avg and the current
avg. In other words, more helper cells which is apparently what you're
trying to eliminate!

I just did this exact same thing for someone who wanted to track their golf
score averages.

Biff

"S3NTYN3L" wrote in
message ...

I think you are correct now that I look at things...

I'm trying to have the averages in row 5 color coded so that it's green
if it's risen and red if fallen. (Reverse that in the case of the dollar
amounts on the left).

Something just now hit me...

Would this be a TREND function I'm thinking of?

I'm also going to have each entry color coded based on if the data
entered is higher or lower than the overall average.

In a nutshell, I'm wanting to be able to see how well my vehicle
mileage is and "guage" (when things start turning red) when it's time
to change the oil, air & fuel filters, give it a tune up, etc.

I'm also wanting to get rid of the cells on the right ( M-V I believe).
I don't like having to hide those columns...


I hope I haven't confused you even more....


--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile:
http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505215