Hi all,
For example's sake and not to sound too confusing here's what i want t
achieve.
I need to get a cell on a spreadsheet to change colour according to
result which is calculated. So for example, in cell A1, the figur
used for the calculation is placed. Cell B1, is where the answer wil
be held. I want cell B1 to go green if the answer is between 1 and 5
and the cell to turn red if anything else.
I'm guessing i need an if statement
if B1 less then 1 or more than 5
cellB1 = red
else
cellB1 = green
But how exactly is this done?
Any feedback and help is much apreciated,
Alex Marchan
--
69679
-----------------------------------------------------------------------
696796's Profile:
http://www.excelforum.com/member.php...fo&userid=1597
View this thread:
http://www.excelforum.com/showthread.php?threadid=27444