Font changes inside formulas

Hi Alix, thanks for your query. Lets say you have an exam mark in cell a1 and you need to get greater than 50 to pass the exam. In B1 you'll have:

=IF(A1>50, "Pass", "Fail")

Now you need to conditionally format B1 with two conditions. First, with the conditionally formatting dialogue box up you need to switch from "Cell Value Is" to "Formula Is" for both conditions and then the formula Condition 1 will be

=A1>50

...which you then need to format as green, and the formula for condition 2 will be

=A1<50

...which you need to apply a bright red font colour. That should do the trick. It doesn't matter what the logical test is in your case, just tease it out of the IF formula in the cell and apply the formatting to the true and false conditions.

Hope this helps,

Anthony