Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 - formatting cells
|
|
|
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 2007 - formatting cells
Resolved · Low Priority · Version 2007
Reply Mon 24 Nov 2008, 16:46Delegate Anne said...
Anne has attended:
Excel Introduction course
Excel 2007 - formatting cells
How would you highlight or emphasise any cells that contain a number that is higher than or lower than a specified value?
For upcoming training course dates see: Pricing & availability
RE: Excel 2007 - formatting cells
Hello Anne
Thank you for your question, and welcome to the forum.
I hope you enjoyed yesterday's training.
You can highlight cells according to the value that is in them, using a feature called Conditional Formatting.
In Excel 2007, you can create a conditional format as follows:
1. Highlight the cells containing the values you wish to apply the conditional formatting to.
2. On the Home ribbon, within the Styles group, click the Conditional Formatting button.
3. Select Highlight Cell Rules, then select the appropriate option for the condition you wish to create (greater than, less than...)
4. Type in the value that is your minimum or maximum (depending on the rule you are creating) then create the format you wish to apply to the cells using the dropdown box on the right. You'll have preset options you can choose from or go to Custom Format to set your own formatting up.
5. Once done, click OK.
I hope this helps.
Amanda
Tue 2 Dec 2008: Automatically marked as resolved.
|