# Conditional Formating not working...

#### albertc30

##### Well-known Member
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

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### CROY1985

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

#### Wagner Morel

##### New Member
albertc30

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

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

#### albertc30

##### Well-known Member
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

##### Active Member
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

##### Well-known Member
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

Replies
3
Views
148
Replies
4
Views
260
Replies
3
Views
459
Replies
1
Views
298
Replies
3
Views
81

1,195,582
Messages
6,010,577
Members
441,557
Latest member
Jbest23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back