Jul 1, 2011 at 01:33 PM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Jul 2, 2011 at 08:35 AM
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 :)