Alix has attended:
Excel Advanced course
Font changes inside formulas
Hello,
2nd question of the day - I'm using an IF function - I would like the True response to be in black and the False response to be in red - can excel do that? If so could someone please tell me how?
Thank you ever so much.
RE: 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
