Conditionally Formatting a cell, based on cells including formulas

Question

I'm trying to highlight a cell A6, if B6 + C6 >74.9%. However, B6 and C6 are calculated values and conditional formatting reads the formula in the cell, not the value it calculates

I can create an if statement with a 1 or a 0:

=if((B6+C6) > 0.749, 1,0)

but if I use the same if statement in the conditional formatting (with out the ,1,0) nothing happens:

=if(b6+C6) > 0.749

I want the cell to turn green, rather than a 1 or a 0.

Answer 1

The syntax of the formula you're using is wrong. In the conditional format formula you don't need an IF statement at all, you can just write out the condition, which evaluates to either TRUE or FALSE.

In this case it's

=B6+C6>0.749

For completion's sake: if you wanted to write a full IF statement, then it would have to look like

=if(B6+C6>0.749,true, false)