Woo hoo! I got it to work! Course you know what it was I finally realized I
was doing wrong? Inputting the wrong column value! D'oh!

Thanks again for all your help! Both of you!

--
Teri Albert


"ken-hup" wrote:

Good original answer however small error..
First condition - Frmula is:
=OR(A1<=-1500,A1=1500) will go (Yellow)..
second Condition - Formula is:
=OR(AND(A1<=-200,A1=-1499),AND(A1=200,A1<=1499)) will go (Red)

Note the equal signs as well

Good Luck



"tralbert" wrote:

No dice. When I input the two formulas all of the cells showed up in red (the
color for the +-1500.
--
Teri Albert


"akphidelt" wrote:

Alright, try this. Assume the test data starts in cell A1 and change
according to your actual data.

Hilight all your data you want the conditional formatting applied to.
Click on format--condition formatting

In the first condition change Cell Value is to Formula Is

Then put in the formula

=OR(AND(A1<-200,A1-1499),AND(A1200,A1<1499))
Then you can change the format to yellow or whatever you want

Then click add to create another condition and once again select formula is
and type in

=OR(A1<=-1500,A1=1500)

Then format this to red or whatever you want.
This should work