Forum home » Delegate support and help forum » Microsoft Excel Training and help » 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. |
Formulas
Resolved · Medium Priority · Version 2003
Reply Wed 21 Oct 2009, 16:23Delegate Aimee said...
Aimee has attended:
Excel Advanced course
Formulas
How can you write a formula or macro to change the color of text in a cell if the math is incorrect. For instance if a number is negative or above a certain number and you want it to stand out in red.
For upcoming training course dates see: Pricing & availability
RE: Formulas
Hello Aimee
Thank you for your question and welcome to the forum.
I think you will be able to accomplish this using conditional formatting.
To apply conditional formatting:
1. Select the cells which you want the highlighting/colour to be applied to.
2. Go to Format - Conditional Formatting.
3. Set a condition, e.g. Cell Value is less than 0.
4. Click the Format button to create the formatting that will be applied if values in the selected cells if the criteria is met, e.g. select red colour on the Patterns tab. Click OK, and OK again to apply your condition to the selected cells.
Kind regards
Amanda
Thu 29 Oct 2009: Automatically marked as resolved.
|