Conditional Formatting

[michael.juska]

I am trying to color one cell based on two conditions to be true in
two seperate cells. For example change cell A to red if cell B is
greater than 9 and cell C is greater than 2. I figured that much out
with this statement. =AND($D$17>=9, $F$17>=2). I have two
questions: 1. Is it possible to drag this condition to apply much
like a formula or autopopluation does in excel, rather than having to
manually enter the similar formula for each text cell that I want to
change under those same conditions? 2. Can I add a condition to that
formula so that the cell color will change under two
circumstances...for example, if (B > 9 and C > 2) or (4 < B < 8 and C

4)?

Thanks for your help.

Michael

 

[JE McGimpsey]

You can choose to make either columns or rows, or both, relative, so
that you can apply the format to different rows/columns. For instance if
you copy

=AND($D17>=9,$F17>=2)

down, XL will adjust the row numbers (but not the Columns, if you drag
across).

You can use more complex criteria, as in your example:

=OR(AND($B1>9, $C1>2), AND($B1>4, $B1<8, $C1>4))

 

[michael.juska]

Thanks, I think that helps out a lot, I modified it to fit my criteria
and used the drag down option to populate multiple cells.

Thanks again!

michael