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