Forum home » Delegate support and help forum » Microsoft Excel Training and help » Font changes inside formulas
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Font changes inside formulas
Resolved · Low Priority · Version 2007
Reply Tue 11 Jan 2011, 17:41Delegate Alix said...
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.
For upcoming training course dates see: Pricing & availability
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
Reply Wed 12 Jan 2011, 16:03Delegate Alix said...
RE: Font changes inside formulas
Thank you so much - this worked a treat!
|