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