Previous Topic Next Topic

Excel

Closed
Gaz - Feb 1, 2010 at 01:59 PM
rizvisa1 Posts 4478 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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses