Conditional Formating not working...

[albertc30]

Hi all.

The above formula should make the data on cell S20 red if the value on cell R25 falls outside the % scope, but it is not working.

=IF(R25>101%,R25<99%)

On cell R25 I have a formula as follows;
=IF(ISERROR(R24/R23),"-",(R24/R23))

Please note that I am now on office 2010 and not 2003.

Any help much appreciated.

Regards,
Albert

 

[CROY1985]

If you change your IF to OR, that should to the trick.

 

[Wagner Morel]

albertc30

Conditional formatting in cell S20 - insert two conditions: =$R$25<99% and =$R$25>101%

Enter in cell A25: = ISERROR((R24/R25),"-")

 

[albertc30]

I though IF was the one to use.

I am confused as to why the OR as it sounds like a second condition to it.

It does work.

Many thanks.

Albert

 

[CROY1985]

To trigger the conditional format you needs your formula to return TRUE. Using OR, simply check whether either condition is True,
and if it is it returns TRUE. If none of the cnditions are true it returns false.

The two conditions on which it should return TRUE are >101% and <99%. So it just checks if either is true.

If could work, but your syntax was incorrect, as it had no false condition for the first test. The below would work as an if formula:

=IF(r25>101%,r25>101%,r25<99%)


I hope that helps, i know i'm not so good at explaining things

 

[albertc30]

I hope that helps, i know i'm not so good at explaining things

It did help mate.

It's funny you should say the above as I am the same when it comes to exaplainning things.

Thanks.

Albert