Prev: Excel 2007 Page Break Adjustments causes a page break each cell
Next: Conditional format will not work without $ (removed to allow copyi
From: Duke Carey on 21 Apr 2010 12:40
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" <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")
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Excel 2007 Page Break Adjustments causes a page break each cell
Next: Conditional format will not work without $ (removed to allow copyi