Conditional Formatting Question with 'OR'

  • Thread starter Thread starter Steve Stad
  • Start date Start date
S

Steve Stad

Is "OR" operator allowed in Excel conditional formatting? If so is there
something wrong with this formula - it does not seem to be working?

=OR(TRIM(K3)="PENDING","INACTIVE")
 
Hi,

Your using the wrong syntax, this will work as a CF

=OR(TRIM(K3)="PENDING",TRIM(K3)="INACTIVE")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
=OR(TRIM(K3)="Pending",TRIM(K3)="Inactive")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Is "OR" operator allowed in Excel conditional formatting? If so is there
something wrong with this formula - it does not seem to be working?

=OR(TRIM(K3)="PENDING","INACTIVE")
 
Dang it!

RagDyeR said:
Hey Duke,

Array Constants are not allowed in CF.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

=OR(TRIM(K3)={"PENDING","INACTIVE"})




.
Click to expand...
 
Back
Top