Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.training - Highlighting 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. |
microsoft.excel.training - Highlighting cells
Resolved · Low Priority · Version Standard
Reply Thu 13 Sep 2007, 16:54Delegate James said...
James has attended:
Excel Intermediate course
Excel Advanced course
Highlighting cells
How do I highlight cells with a number over a certain value in a colour?
For upcoming training course dates see: Pricing & availability
RE: Highlighting cells
Hi James. You need to use conditional formatting to do this. Select your cell and then select Format - Conditional Formatting. This will bring up a dialog box in which you can specific the criteria you want to follow and the formatting change you want to occur.
Hope this helps,
Anthony
|