change background color of a cell with an "IF" command?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee - 30 Jun 2007 19:28 GMT

I have a command using the IF function that is as follows:
=IF(M3>=80,"YES","NO")

I would like to be able to add a green background if the YES condition is
met and a RED background if the NO condition is met. is there a line of code
that will do this.

Reply to this Message

Sandy Mann - 30 Jun 2007 19:41 GMT

Use Conditional Formatting with the the formulas:

=$M$3>=80

and

=$M$3<80

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>I have a command using the IF function that is as follows:
> =IF(M3>=80,"YES","NO")
[quoted text clipped - 3 lines]
> code
> that will do this.

Reply to this Message