Excel Conditioning Formatting

[Help2018]

Cell B44 needs to be green if greater than B43 and red if less than B43
Then need to be able to copy that across Row44 for each month Jan etc
Then copy down to so that in Row45 B45 needs to be green if greater than B44 and red if less than B44.

In Cell B44 I use Greater than and Less than in Conditional Formatting then use the paintbrush to copy across, but sometimes the cell colour is incorrect. Is there a better way to do this and one that gives the correct colour every time?

Thanks, your help is greatly appreciated as I am going crazy with this

 

[Becky]

Welcome to the forum

Have you tried doing conditional formatting with a formula? Highlight the relevant cells (ie cells B44 to M46 assuming the table goes up to December), select Conditional Formatting > New Rule > Use a formula to determine which cells to format. In this way you can add two rules, the first being =B44<B43 (choose red formatting) and the second being =B44>B43 (green formatting). When you use format painter it should apply this rule to new cells - ie it will compare the value of that cell with the cell above and make it red or green accordingly.

Hope this helps!

 

[Help2018]

Thank you Becky. Used your suggestion and its perfect!

 

[Becky]

Glad to hear it worked well for you!