Excel Functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

spotseven - 02 Jun 2007 20:40 GMT

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

Reply to this Message

Paul Lautman - 02 Jun 2007 20:50 GMT

> hi guys, just wondered if anyone knew which function i would use to
> do this, because im fairly novice with excel:
[quoted text clipped - 5 lines]
>
> any help would be seriously appreciated. thanks

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

Reply to this Message

spotseven - 02 Jun 2007 21:53 GMT

thanks very much, problem solved

> > hi guys, just wondered if anyone knew which function i would use to
> > do this, because im fairly novice with excel:
[quoted text clipped - 7 lines]
>
> You don't want a function. Use Format->Conditional Formatting...

Reply to this Message

Dave Peterson - 02 Jun 2007 21:26 GMT

Select the cell and try Format|Conditional formatting.

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

> hi guys, just wondered if anyone knew which function i would use to do this,
> because im fairly novice with excel:
[quoted text clipped - 4 lines]
>
> any help would be seriously appreciated. thanks

Signature

Dave Peterson

Reply to this Message

spotseven - 02 Jun 2007 21:48 GMT

Thanks very much, this solved the problem.

> Select the cell and try Format|Conditional formatting.
>
[quoted text clipped - 8 lines]
> >
> > any help would be seriously appreciated. thanks

Reply to this Message