Conditional formatting using OR() & AND()

  • Thread starter Thread starter abulawski
  • Start date Start date
A

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
 
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)
abulawski said:
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
Click to expand...
creating financial statements
 
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)
abulawski said:
using this, but I know my formula is messed up/ not formatted right. I
used:
Click to expand...
creating financial statements
 
Back
Top