Conditional Formating - work around?

[kph]

I need to do some conditional formatting. I am using the formula selection.
My formula contains more than 3 conditions.

What is the work around in Excel 2010 not using VBA method.

 

[Jonmo1]

There is no limit (other than length of formula) to the number of conditions you can have in conditional formatting.

The limit is the number of formats that can be applied.


Can you describe your conditions, and the formats to be applied to those conditions...


edit...
After reading further, you say you have XL2010...
The limit of 3 is only in XL2003 and earlier..

 

[kph]

After reading your response - do I understand correctly that the xl2010 is limited only to 3 conditions. Does the xl2011 allow for unlimited?

My formula has 4 conditions which put a word in the cell with a color shading.
Here is my formula -

=IF(AND(H9>0,I9>0),"Green",IF(AND(H9>0,I9<0,),"Blue",IF(AND(H9<0,I9>0),"Red",IF(AND(H9<0,I9<0),"Orange",""))))

 

[Jonmo1]

Nope, Version 2003 and earlier are limited to 3 conditional formats.
Versions 2007 and above can do significantly more than 3 conditional formats.
Not sure how many, but more than sufficient.

You enter 4 different conditional format formulas.

=AND(H9>0,I9>0) - format Green
=AND(H9>0,I9<0) - format Blue
=AND(H9<0,I9>0) - format Red
=AND(H9<0,I9<0) - format Orange


Hope that helps.

 

[shg]

What should happen when either H9 or I9 = 0?

 

[kph]

OK - I see how it can be done - thank you very much.

 

[kph]

Shg - in regards to if it is zero - it will post no color or text. The objective is to have a visual (color) that can be quickly scanned.

This formula is for scouting stocks in relationship to the closing price and volume - measured 10 days apart. The green and blue are the ones will be most profitable, while the orange and red - stay away from.

 

[kph]

Here is the formula that is used to measure the present price and the 10 day old price -- =100*((D4/G4) -1) and a similar one for the present volume and the 10 day old volume.

Then you use the previous formula to measure the two which will tell you which is most valuable.