Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Auto colour change
|
|
|
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-courses - Auto colour change
Resolved · Low Priority · Version Standard
Reply Thu 6 Dec 2007, 17:04Delegate Stacey said...
Stacey has attended:
Excel Intermediate course
Auto colour change
How do you get the cells to automatically change colour if figure entered is above or below target set.
For upcoming training course dates see: Pricing & availability
RE: auto colour change
Hi Stacey, Thank you for your post, I hope you enjoyed the Excel Intermediate Course, In answer to your question: To do this I would choose Excel's Conditional Formatting Option.
Select the cell or range of cells that you wish to control: From the Menu Bar choose Format, Conditional Formatting. This will open a dialog box which will allow you to choose from a number of numerical operators ie above, below, equal to etc. etc., and to enter the value you have chosen as your target. By clicking on the Format button you will open the Format Cells dialog box which will allow you to apply Font Colouring, Cell Colouring and Cell Borders, or any combination of the three. You can then click on the Add button to add any additional condiditions that you wish to apply, in your case you would have two options, one to format the cells for above target, the second to format the cells for below target. I hope that helps, best regards Pete
|