Multiple Column Conditional Formatting

[Colleen]

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

 

[JE McGimpsey]

one way:

Select K2:

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

 

[Colleen]

Thanks JE. It works great.