Conditional Formatting Question with 'OR'

[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")

 

[Mike H]

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.

 

[Duke Carey]

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

 

[RagDyeR]

=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")

 

[RagDyeR]

Hey Duke,

Array Constants are not allowed in CF.

 

[Duke Carey]

Dang it!

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"})




.