98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » If formula
If formula
Resolved · High Priority · Version 2007
Mon 20 Jul 2009, 18:35Delegate Richard said...
Richard has attended:
Excel Advanced course
If formula
When using the If formula, is there a way to change the colour of the cell as well as have a generic statement. For example: if you are looking at a basic budget spreadsheet and you want the if formula to state whether you are over or under budget, can you also change the cell to green if under and red for over.
Tue 21 Jul 2009, 09:30Trainer Amanda said...
RE: If formula
Hello Richard
Thank you for your question.
It should be possible to do this using Conditional Formatting (which lives on the Home Ribbon).
1. Select the cells that you want to colour red or green.
2. Go to Home - Conditional Formatting-Highlight Cell Rules.
3. I think the Text that Contains option should be ok for what you want to do - select this, enter over budget and pick your formatting to apply. Repeat steps 2 & 3 to set up the formatting for under budget as well.
I hope this helps.
Kind regards
Amanda
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:Using the Quick Access Toolbar in Excel2010The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010. |
