Changing cell colour based on values

BenHoughton1978

New Member
Joined
Feb 4, 2020
Messages
3
Office Version
  1. 2013
Platform
  1. Windows
Hi all

Can anyone help (or point me to a youtube video?) please?

I need to change the colour of cell D6 to either red, yellow or green based on the total numerical value inputted in to cells B5 - B26 combined

Any ideas how to do this? Ideally I'd like B5-26 to be a simple yes/no drop down if that's easy to do as well?

Thank you in advance!
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
707
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
If I understand correctly, the basic idea would be similar too something like below.
For simplification I've added the SUM in the cell you want to colour.

1586346344326.png


Not sure I understand how numerical values can be a "Yes/No" drop down?
But a drop down is this kind of data validation, via Data Tools on the Data Ribbon.
1586346522967.png
 

BenHoughton1978

New Member
Joined
Feb 4, 2020
Messages
3
Office Version
  1. 2013
Platform
  1. Windows
thats perfect thank you....but how do I get the first SUM box up?
 

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
707
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
In D6 = SUM(B5:B26) , would do, no?
 

Watch MrExcel Video

Forum statistics

Threads
1,127,758
Messages
5,626,686
Members
416,200
Latest member
Pulsar3000

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top