Conditional Formulas In Excel a Challenge

[Guest]

Outstanding help on my earlier post Thank you !! Now to take it a little
further, this will show how lame I really am.

If the following is one condition In D Type
=IF(AND(A10+B10>0,A10+B10<60),(IF(OR(C10="xo",C10="ox"),385*8)))

and I want to add in another condition like the following
=IF(AND(A10+B10>60,A10+B10<72),(IF(OR(C10="xo",C10="ox"),420*8)))

and yet another condition like the following
=IF(AND(A10+B10>0,A10+B10<60),(IF(OR(C10="xox",C10="oxo"),500*8)))

and if I wanted to add over 50 different formulas like those above in D
How do I work this ?

also on the following formula in E type
=IF(AND(A8+B8>0,A8+B8<60),(IF(OR(C8="xo",C8="ox"),150)))
C8 will never have to rely on A or B to achieve its Value I just want to be
able to change the xo, ox = 150 to maybe pdox, pdxo = 300 I also want
to add this and many different scenarios of this formula in E

Now how did all of you learn this stuff !!! I know "read the excel book"
I tried and .. trouble I could not do it !!!! Thank you for your
help,,, If you only knew how many others you will be helping with these
formulas... Roch Miller

 

[David McRitchie]

You are limited to 3 conditions for Conditional Formatting, after
the 3 formulas you can't add any more. Specifically a cell can
only be given 1 of 3 color or none from Conditional Formatting.

If you want more then that you have to use an event macro. Excel
only supports 56 colors and many of them are somewhat indistinguishable
on some monitors namely laptops. Plus any text must be distinguishable
on the background.

Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm