Conditional Formatting Question with 'OR'
in [Functions]
|
Prev: Excel 2007 Page Break Adjustments causes a page break each cell
Next: Conditional format will not work without $ (removed to allow copyi
From: Steve Stad on 21 Apr 2010 11:46 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")
From: Mike H on 21 Apr 2010 11:53 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")
From: Duke Carey on 21 Apr 2010 11:56 =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")
From: RagDyeR on 21 Apr 2010 11:58 =OR(TRIM(K3)="Pending",TRIM(K3)="Inactive") -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message news:6142E518-E134-4272-89CE-084DE0CFEED4(a)microsoft.com... 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")
From: RagDyeR on 21 Apr 2010 12:01
Hey Duke, Array Constants are not allowed in CF. -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Duke Carey" <DukeCarey(a)discussions.microsoft.com> wrote in message news:60C26D06-B968-442B-AED2-86926728C50C(a)microsoft.com... =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") |