Conditional Formatting Question with 'OR'

's Computer Specifications

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

's Computer Specifications

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.

"Steve Stad" wrote:

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

's Computer Specifications

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

"Steve Stad" wrote:

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

's Computer Specifications

=OR(TRIM(K3)="Pending",TRIM(K3)="Inactive")
--

HTH,

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

"Steve Stad" <(E-Mail Removed)> wrote in message
news:6142E518-E134-4272-89CE-(E-Mail Removed)...
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")

's Computer Specifications

Hey Duke,

Array Constants are not allowed in CF.
--

Regards,

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

"Duke Carey" <(E-Mail Removed)> wrote in message
news:60C26D06-B968-442B-AED2-(E-Mail Removed)...
=OR(TRIM(K3)={"PENDING","INACTIVE"})

"Steve Stad" wrote:

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

's Computer Specifications

Dang it!

"RagDyeR" wrote:

> Hey Duke,
>
> Array Constants are not allowed in CF.
> --
>
> Regards,
>
> RD
> -----------------------------------------------------------------------------------------------
> Please keep all correspondence within the Group, so all may benefit !
> -----------------------------------------------------------------------------------------------
>
> "Duke Carey" <(E-Mail Removed)> wrote in message
> news:60C26D06-B968-442B-AED2-(E-Mail Removed)...
> =OR(TRIM(K3)={"PENDING","INACTIVE"})
>
> "Steve Stad" wrote:
>
> > 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")
>
>
> .
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Question	lindsayr	Microsoft Excel Misc	7	30th Apr 2008 02:52 AM
Conditional Formatting question	jamespg	Microsoft Excel Discussion	0	30th Jan 2007 07:11 PM
conditional formatting question	buachille	Microsoft Excel Discussion	2	6th Apr 2006 09:08 PM
question on conditional formatting	Josh	Microsoft Excel Worksheet Functions	2	29th Apr 2004 05:51 PM
conditional formatting question	Stanton A Hershman @ Work	Microsoft Excel Worksheet Functions	1	23rd Mar 2004 05:33 PM