"OR " condition for conditional format

[var]

Hi There Iam looking for OR condition for conditional formatting.

Example:

Conditional format formula for unlock cells is =CELL("PROTECT",E5)=0

I want a cell to change its color either E5 or F5 is unlock

can i write =CELL("PROTECT",E5)or("PROTECT",H5)=0 ( does not work)

thanks
var

[Pete_UK]

You don't use OR like that. Try it like this:

=OR(CELL("PROTECT",E5)=0,CELL("PROTECT",H5)=0)

not sure if you mean F5 or H5

Hope this helps.

Pete

[var]

Hi thanks for reply, that works but....................................

my work sheet has been set up in a different way based on our requirements.

I want my conditional format must be disabled if E5 or H5 are locked. how do i go about it..


regards
var

[Pete_UK]

This is what you said before:

I want a cell to change its color either E5 or F5 is unlock

Are you now saying the opposite of that? I don't understand what you mean by "disabled".

Pete

[var]

yes exactly. i want opposite of that..
regards
var

[Pete_UK]

Put NOT( ... ) around it all then.

Pete

[var]

Apologies,

Let me explain waht I want..

cell A1 must be gary in color only if E5 and F5 are unlocked.

If Both OR one out of E5 , F5 is locked , then conditional format should not work. so A1 cell turns to white color (default color).

Hope i'm clear this time.

regards-var

[daddylonglegs]

Try AND

=AND(CELL("PROTECT",E5)=0,CELL("PROTECT",H5)=0)

Note that changing the cell from locked to unlocked or vice versa won't trigger a change in the conditional formatting automatically......

[var]

I'm kind of thinking too much.....i think i shd use AND instead of OR..
i got it


thanks..var