Conditional format with formula?

[jackdiamond]

Afternoon,

I have the formula =IF(F4>=K4,"YES","").

However, when the result is yes, I want the cell to turn green and if no, turn red.

Does anyone know how I can do this please?

I had conditional formatting set up for the colour change but when I added a formula, it all went pear shaped!

Any help appreciated
Thanks
Stu

 

[MrKowz]

Select the range you want the conditional formatting on, go to conditional formats, and make it:

1. Cell Value -- Is Equal to -- ="Yes" -- Green format
2. Cell Value -- Is Equal to -- ="No" -- Red Format

 

[jackdiamond]

I already had that set up in conditional formatting and it worked fine.

then I decided that I wanted the cell to populate "Yes or No" itself by using the formula =IF(F4>=K4,"YES","").

This then stopped my conditional formatting from working.

Any idea why?

 

[hallingh]

Hmmm... Is it not working regardless of whether the cell displays Yes or No?

 

[jackdiamond]

No.

The formula works fine displaying the yes or no but it seems to have over ridden the conditional formatting?

 

[MrKowz]

Go into conditional formatting and make sure it doesn't show something like =""Yes"" (note the double quotes). If it does, retype in there:

="Yes"

 

[hallingh]

Yea sorry I was unclear I meant does the conditional formatting not work regardless of what the cell displays

 

[jackdiamond]

It was the double ""

Thanks very much for all your help

Stu