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