I wasn't using conditional formating. I was just using the formula. I tried
your revised formula but the response was not what I needed. Here's my
problem:
I am trying to get a True response whenever there was a change of 10,000 or
10%.

2008 2007
Cash 110,000 100,000
Deposits 0 12,000
Receivables 15,000 0
Interest 30,000 15,000

Based on the above data I would expect Cash = False, Deposits =True,
Receivables =True and Interest = True.

Now I just need a formula to figure this out. One that when divided by a
negative number gives me a True or False response.

Any suggestions?

"FSt1" wrote:

hi
are you using conditional formating. if so, you should not get a #Div/0
error. only
not format in cell. if your are using just the fomula try this.
=IF(A1=0,"",IF(AND(A1-B110000,(A1-B1)/A10.1),1,0))

regard
FSt1

"Bookmdano" wrote:

Thanks for the assitance but I have a new twist. I also need a "True" return
if A1=0 and B110,000. Since I'm dividing by zero (A1) my response is #DIV/0!

Any suggestions?

"Barb Reinhardt" wrote:

If you are talking about formulas in conditional formats, you don't need the IF

AND(A1-B110000,(A1-B1)/A10.1)

is all you need.

Just put it in the cell that needs the condition set.

Look, I didn't hit enter between Subject and message. :)
--
HTH,
Barb Reinhardt



"FSt1" wrote:

hi
formulas return values, they cannot perform actions such as highlight cells.
but if you put the formula in conditional formating, it would work.
formula is......=IF(AND(A1-B110000,(A1-B1)/A10.1),1,0)...pick your color.

regards
FSt1

"Bookmdano" wrote:

I am comparing data from 2 columns. What I want to do is have a formula that
says if A1-B110,000 and (A1-B1)/A1 10% then highlight cell C1. Can this be
done?

Thanks