Conditional Formatting with 2 variables

[GSXR]

I've got a condtional statement that reads CELL VALUE GREATER THAN =.1*AO55+AO55

So it does the formatting if my actual value is 10% more than my budget value. Works great, I wanted to add to it saying only do the conditonal format if the difference is greater than 1000. tried a few things but it doesn't seem to take. Thanks!


USING EXCEL 2007 AND CONDITIONAL FORMATTING.

 

[powerdink]

909.09 is the highest number you could get and stay below 1000 when adding 10%. Why don't you just look for cells that are greater than 909.09?

 

[Marcelo Branco]

Not sure if i understood correctly the 1000 difference. Assuming A1 as the target-cell is it
A1 - AO55 > 1000
or
A1-1.1*AO55 > 1000

If the first one, maybe this

=AND($A$1>1.1*$AO$55,($A$1-$AO$55)>1000)

if the second

=AND($A$1>1.1*$AO$55,($A$1-1.1*$AO$55)>1000)

M.

 

[GSXR]

Thanks guys - I still can't get it to work. I got this first part to work it highlights the cell if the variance is greater than 10%.

=.1*AO55+AO55

But i still can't add the part about not highlighting if the variance is less than 1000.

I tired this statement with and without the Target cell...no success.
AND($A$1>1.1*$AO$55,($A$1-1.1*$AO$55)>1000)

 

[Marcelo Branco]

Hi GSXR,

Try this
=$A$1-1.1*$AO$55>1000

Format button and picked Fill yellow Ok, Ok

After this i inserted 500 in AO55, and tried in A1
1000 ---> no highlight
1550 ---> no highlight
1551 ---> highlight because it is greater than 1.1*500 + 1000 = 1550

Is it what you need?

M.

 

[GSXR]

Thanks Marcelo

 

[Marcelo Branco]

You are welcome

M.