Excel

Closed
Gaz - Feb 1, 2010 at 01:59 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 1, 2010 at 02:32 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 1, 2010 at 02:32 PM
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
0