Conditional Formatting based on True/False outcome of IF formula

[MHudson]

Simple issue which I believe will have a simple answer, but I cannot figure it out for the life of me.

I have an IF formula in a cell, I need to have the cell conditionally formatted green if the result of the IF formula is TRUE, and red if the result of the IF formula is false. Any Ideas?

 

[vasim]

http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/

 

[Jack]

@MHudson What might be tricking you as it still catches me at times is even though you are putting in the logic of an IF statement, in CF it's a little different in that it only wants to know what to do if the result is TRUE as it will ignore the FALSE. So enter =A1="YES" into the 1st condition formula in CF, conditioned as green, (not =IF(A1="Yes" as you would reasonably think). Then the 2nd condition =A1<>"Yes" conditioned as red. Basically each condition wants to know what to do if it encounters a TRUE result to trigger the conditional formatting. You can test these outside of CF in a normal cell formula and if you can't get a TRUE or you get an error CF will fail. Hope this helps.

 

[Luke M]

To expand on what John said, if the result of the cell is already a TRUE/FALSE output, your CF rules would be:

=A1

Format green

=NOT(A1)

Format red

 

[MHudson]

Awesome stuff guys...John, it worked exactly as you typed it out, always love that! Now how do I go about altering the formulas if I want to apply each condition to a table of cells?


Thanks again!!!

 

[Luke M]

As long as you don't use absolute references in your formulas, you should be able to copy the formatting to the other cells in table.


or


Select the entire table of cells to format, take notice of which cell is active, (say, C3), and then just write the CF formula with respect to c2, eg:

=C3="Yes"

 

[MHudson]

Perfect, thanks Luke, worked just as I needed...

 

[linda006]

Football kits can also include several optional items, such as wristbands, leg warmers, body warmers and head bands. Some players like to personalize their look, benefiting from the relatively loose rules in ice hockey jersey. You can see some players wearing the cheap nfl jerseys and football jerseys in winter; some players do not like wearing short college football jerseys, while others have always some wristband or even head protectors and gloves.