Excel conditional formatting help

Closed
JPMorini - 1 Jul 2011 à 13:33
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Jul 2011 à 08:35
Hello,

Really need some help with an Excel problem.
I have to try and change the cell background colour under certain conditions.
I've tried conditional formatting but it only allows 3 conditions, however i need more :/
Anyone able to help?


This is my problem:

Value more than -15.01 (e.g -300.....etc) = cell background of red
Value between -15.00 and -5.01 = cell background of orange
Value between -5.00 and -0.01 = cell background of green

If the cell contains no value or 0.00 = cell background clear

Value between 0.01 and 5.00 = cell background of green
Value between 5.01 and 15.00 = cell background of orange
Value more than 15.01 (e.g 300.....etc) = cell background of red


If anyone could help me i would really appreciate it :)

Thank for in advance



Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
2 Jul 2011 à 08:35
For that you need to have a custom function. Search the forum for "conditional format for more than 3) . this issue has been addressed.