Conditional Formatting
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 |
Conditional Formatting
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 |
All times are GMT +1. The time now is 10:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com