Multiple Rows for 4 Conditional Formats

Closed
GZ2525 - Jul 8, 2010 at 09:58 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 9, 2010 at 05:02 PM
Hi,

I need to make four different color conditonal formats depending on a few statements. I know what statements I need, but how to I get it into a macro so that if I have the formulas, they will change for each cell:

Formula is =(B2/D2=1) turns the cell Green
Formula is =OR(B2/D2<0.95, B2/D2>1.05) turns the cell Yellow
Formula is =OR(B2/D2>=0.95, B2/D2<=1.05) turns the cell Blue
Formula is =OR(B2=0, D2=0) turns the cell Red


I need it so that it changes B3/D3 for all those and so on?

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 9, 2010 at 05:02 PM
0