Multiple Column Conditional Formatting

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

one way:

Select K2:

CF1: Formula is =AND(K2>10,F2>100)
Format1: <patterns>/Red

In article <[email protected]>,
"Colleen" <[email protected]> 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

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 <[email protected]>,
> "Colleen" <[email protected]> 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
>