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.

Use Conditional Formatting with the the formulas:

=$M$3>=80

and

=$M$3<80

--
HTH

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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"Lee" <(E-Mail Removed)> wrote in message
news:2B8A8C63-E910-4A19-BBC2-(E-Mail Removed)...
>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.
>