PC Review


Reply
Thread Tools Rate Thread

Conditional Formatting Question with 'OR'

 
 
Steve Stad
Guest
Posts: n/a
 
      21st Apr 2010
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")
 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      21st Apr 2010
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")

 
Reply With Quote
 
Duke Carey
Guest
Posts: n/a
 
      21st Apr 2010
=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")

 
Reply With Quote
 
RagDyeR
Guest
Posts: n/a
 
      21st Apr 2010
=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")


 
Reply With Quote
 
RagDyeR
Guest
Posts: n/a
 
      21st Apr 2010
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")



 
Reply With Quote
 
Duke Carey
Guest
Posts: n/a
 
      21st Apr 2010
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")

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:52 PM.