Excel conditional formatting help

Closed
JPMorini - Jul 1, 2011 at 01:33 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 2, 2011 at 08:35 AM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 2, 2011 at 08:35 AM
For that you need to have a custom function. Search the forum for "conditional format for more than 3) . this issue has been addressed.
0