High Medium and low

[mobileangus]

Hi,

I need to add a colour and Text in a cell influenced by the number in a second cell, so if the number is equal or between 1 and 2 i want the cell to go green with the text 'LOW', if the number is equal or between 3 or 4 i want the cell to go yellow with the text 'MEDIUM' and if it is equal or between 6 and 9 i want the cell to go red with the text 'HIGH'.

I have attached an example.

Thank you for your help.

Regards,
Stuart.

[SDCh]

Try this:

Please Login or Register  to view this content.

and for colour, use conditional formating.


Regards,
SDCh

[benishiryo]

hi Stuart, how about 5? if 5 is excluded, try:
=IF(AND(C4>=1,C4<=2),"LOW",IF(AND(C4>=3,C4<=4),"MEDIUM",IF(AND(C4>=6,C4<=9),"HIGH","")))

otherwise, it could be much shorter (considering HIGH to be 5-9)
=IF(C4<=2,"LOW",IF(C4<=4,"MEDIUM",IF(C4<=9,"HIGH","")))

select the range you want to apply to (i.e. A4)
in Excel 2007 & above, go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
in Excel 2003, go to Format -> Conditional Formatting -> Formula is:
=A4="HIGH"

[dilipandey]

Hi Stuart,

Try using below formula:-

Please Login or Register  to view this content.

Also for conditional formatting, just press alt + o+ d and see the simple logics I used there..

See attached:- Example High, Medium and Low.xls


Regards,
DILIPandey
<click on below * if this helps>