98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2010 - building a macro ( if function?) | Excel forum
Excel 2010 - building a macro ( if function?) | Excel forum
Resolved · Urgent Priority · Version 2010
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
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
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 tip:Create Equations in Excel 2010Here's how to create basic mathematical |