Conditional formatting using OR() & AND()

[abulawski]

I am trying to find a formula to use for condition formatting. I trie
using this, but I know my formula is messed up/ not formatted right.
used:
=OR(N4<>0,P4<>0) AND(X4="Y",R4<>0)

I want the formula to say:

Apply conditional formatting if:
X4=Y and R4<>0

AND
either N4 OR P4 is <>0 (but not both--it's not possible for both cell
to have an entry.)

So, in total I am looking for 3 cells in order to apply conditiona
formatting.

Can anyone help? Thank you

 

[Don Guillett]

I may not quite understand what you want but try
=OR(N4<>0,P4<>0, AND(X4="Y",R4<>0))

--
Don Guillett
SalesAid Software
(e-mail address removed)

I am trying to find a formula to use for condition formatting. I tried
using this, but I know my formula is messed up/ not formatted right. I
used:
=OR(N4<>0,P4<>0) AND(X4="Y",R4<>0)

I want the formula to say:

Apply conditional formatting if:
X4=Y and R4<>0

AND
either N4 OR P4 is <>0 (but not both--it's not possible for both cells
to have an entry.)

So, in total I am looking for 3 cells in order to apply conditional
formatting.

Can anyone help? Thank you.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[Guest]

Or maybe you need

=AND(X4="Y",R4<>0,OR(N4<>0,P4<>0))

Good Luck,
Mark Graesser
(e-mail address removed)


----- Don Guillett wrote: -----

I may not quite understand what you want but try
=OR(N4<>0,P4<>0, AND(X4="Y",R4<>0))

--
Don Guillett
SalesAid Software
(e-mail address removed)

using this, but I know my formula is messed up/ not formatted right. I
used:

creating financial statements