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

Select the cell whose color you want to change. In the toolbar go t
Format Conditional Format. Enter the required condition i.e. if Cel
Value is between and in the boxes enter 1 and 5.

- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27444