Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2010 - building a macro ( if function?)
|
|
|
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. |
Excel 2010 - building a macro ( if function?)
Resolved · Urgent Priority · Version 2010
Reply Thu 10 Nov 2011, 12:41Delegate Sylvia said...
Sylvia has attended:
Powerpoint Intermediate Advanced course
Excel Intermediate course
Excel 2010 - building a macro ( if function?)
Hello. I would like to build a macro so that the font in a certain cell ( numbers) change colors when they reach certain levels. For example:
Lower than 75%: figure in green
- Between 75% and 150%: figure in orange
- Higher than 150%: figure in red
Thank you.
Sylvie
For upcoming training course dates see: Pricing & availability
RE: Excel 2010 - building a macro ( if function?)
Hi Sylva, thanks for your query. You should consider using conditional formatting to do this, it would be a much simpler solution to the problem than using a macro and code!
Hope this helps,
Anthony
|