Excel Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
spotseven said:
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
Click to expand...

You don't want a function. Use Format->Conditional Formatting...
 
Select the cell and try Format|Conditional formatting.

You can specify up to 3 rules (in xl2003 and below). Sounds like a perfect fit.
 
Thanks very much, this solved the problem.

Dave Peterson said:
Select the cell and try Format|Conditional formatting.

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