Multiple Rows for 4 Conditional Formats

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768