Excel Conditioning Formatting


Joined
Feb 23, 2018
Messages
2
Reaction score
1
upload_2018-2-23_14-58-45.png

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 :)
 

Attachments

  • upload_2018-2-23_14-54-59.png
    upload_2018-2-23_14-54-59.png
    14.6 KB · Views: 95
  • upload_2018-2-23_14-57-9.png
    upload_2018-2-23_14-57-9.png
    17.4 KB · Views: 90
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top