Excel [Closed]

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

I need to colour code one cell as a result of many for a risk assessment

thus if the multiple cells equate to less than a figure, a certain colour appears in one cell in the conclusion and if it is less than another figure another colour appears (traffic lights)


Can anyone help

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
I think you are looking for conditional formatting.
You can click on format and pick up conditional formatting. From the drop down pick the option "Formula is". Define your formula. Click on "Format..." and then click on "Pattern". Chose the color your want

Example

I want cell A1 to turn red, if b1+b2+b3+b4 >10
I want cell A1 to turn yellow, if b1+b2+b3+b4 more than 5 but less than 10
I want cell A1 to turn green, if b1+b2+b3+b4 is more than 0
I want cell A1to have no color if b1+b2 +b3+b4 is none of above

I would click of cell A1 and then go to format and pick conditional formatting
for condition 1, I add =SUM(B1:B4) >10 and then go to FORMAT, PATTERN and choose red
for condition 2, I add =SUM(B1:B4) >5 and then go to FORMAT, PATTERN and choose yellow
for condition 3, I add =SUM(B1:B4) >0 and then go to FORMAT, PATTERN and choose green

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!