Re: Multiple Column Conditional Formatting

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks JE. It works great.
--
Many thanks for your help Collee


"JE McGimpsey" wrote:

> one way:
>
> Select K2:
>
> CF1: Formula is =AND(K2>10,F2>100)
> Format1: <patterns>/Red
>
> In article <F025919D-C098-4210-874C-FCB2743AB231@xxxxxxxxxxxxx>,
> "Colleen" <Colleen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > Hi,
> >
> > I'm needing some help with performing a multiple column condition formatting.
> > I have tried many "forumula is" in the conditional formatting with no
> > success. I'm missing something.
> >
> > What I would like to have happen is, if the 2 conditions are true then I
> > want the field to be color filled.
> >
> > Example:
> > if the numeric value in k2>10 and the numeric value F2>100 then I would
> > like cell K2 to be filled in red.
> >
> > Many thanks for your help Colleen
>
.