OR function

[Ir1e]

I want to create a conditional format

it should turn red if Y8 OR AS8 is blanc

I thought it was this

=OR(Y8="";(AS8=""))

but it still only turns red if BOTH are blanc!

ah driving me nuts!

[Jonmo1]

Don't think this is the problem, but you have extra unneeded () in there.
Try
=OR(Y8="";AS8="")

If this still only formats if BOTH are blank, then 1 or both of your cells are not really blank.
Do those cells contain formulas? Can you post those formulas?

[Ir1e]

Hi thanks for your help

no didn't work

the fields are empty!

[bebo021999]

Try this:
=OR(AND(Y8="",AS8<>""),AND(Y8<>"",AS8=""))

[Jonmo1]

the fields are empty!

well it certainly doesn't appear that way..

What does it return if you enter the formula directly in a cell (not conditional formatting)?
Also, do them seperately
=Y8=""
=AS8="'
?

[Andy Pope]

the OR test should work is the cells are actually empty.

check the CF formula has not changed the cell references due to relative cell references.

is still stuck post workbook example

[Ir1e]

=or(and(y8="";as8<>"");and(y8<>"";as8="")) = false
=y8="" = true
=as8="" = true

[Jonmo1]

I can't see any reason for it to not work.

It's probably time to post an example workbook that is displaying this behavior.

[Ir1e]

I can't see any reason for it to not work.

It's probably time to post an example workbook that is displaying this behavior.

ehmmmm sorry I don't know how to add a file on the forum???

[Jonmo1]

Click Go Advanced at the bottom right
Then find the Attachments button (looks like a paperclip)
Should be self explainatory from there.

[Ir1e]

ok here it is

[Jonmo1]

Which cell in that book is displaying the behavior you've described?

I don't see any conditional formats with OR in them..
Your dataset doesn't even extend out to column AS...

[Ir1e]

I made it so that if anything is filled in in certain regions then the price turns red
so my colleagues know they need to provide that currency

but there are more than one that use Dollars or Euros
(I marked the X's that is should be)

I though it was easier to use the blanc options so now they turn white if they are blanc...


but now I'd like if either US (E4) OR CAN (Y4) is empty to turn AE4 white but also if both are empty
but the exact opposite happens

[Ir1e]

Which cell in that book is displaying the behavior you've described?

I don't see any conditional formats with OR in them..
Your dataset doesn't even extend out to column AS...

yeah I copied a part of the file

I can't share business stuff here....

[Jonmo1]

I really think you should reverse the logic of your existing conditional formats...

You currently have it set so that
The Standard Fill is Yellow for the whole sheet.
And applying conditional formatting to the whole sheet that says if the cell is blank make it white.

Reverse that.
Set the standard format to White and use conditional formatting to apply yellow formats when a cell is NOT blank.

That's where I would start.

And for testing 2 cells, it would be
=OR($E4<>"",$S4<>"")

[Ir1e]

and with the red part???
those are not the ones that need to be filled to change the color

I don't know how to do that? especially not if two fields need to be checked

[Jonmo1]

Let's step back to post #8

Post a workbook that currently displays the incorrect behaviour you're describing.
Where an OR formula doesn't do what you expect it to do in conditional formatting.
The book you posted does not do this.

It's very difficult to visualize what you're trying to achieve.

It's just as important to understand which cells you want to change color, as it is to understand which cells the formula refers to.
so which cells do you put the CF in, and which cells does that formula refer to, and what results do you expect.

[Ir1e]

Thanks everybody!

Finally was able to figure it out!

I reversed the logic and then =OR(E4<>"";S4<>"") did the trick!

I attached the result!