Excel Functions

[spotseven]

hi guys, just wondered if anyone knew which function i would use to do this,
because im fairly novice with excel:

Basically if the cell value is above 110 i want the cell to turn green
if the cell value is between 110 and 105 i want it to turn yellow
if the cell value is below 105 i want it to turn red

any help would be seriously appreciated. thanks

 

[Paul Lautman]

hi guys, just wondered if anyone knew which function i would use to
do this, because im fairly novice with excel:

Basically if the cell value is above 110 i want the cell to turn green
if the cell value is between 110 and 105 i want it to
turn yellow if the cell value is below 105 i want it to
turn red

any help would be seriously appreciated. thanks

You don't want a function. Use Format->Conditional Formatting...

 

[Dave Peterson]

Select the cell and try Format|Conditional formatting.

You can specify up to 3 rules (in xl2003 and below). Sounds like a perfect fit.

 

[spotseven]

Thanks very much, this solved the problem.

Select the cell and try Format|Conditional formatting.

You can specify up to 3 rules (in xl2003 and below). Sounds like a perfect fit.

 

[spotseven]

thanks very much, problem solved

You don't want a function. Use Format->Conditional Formatting...