Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
|
|
|
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
Resolved · Low Priority · Version 2007
Reply Tue 16 Nov 2010, 11:45Delegate Fiona said...
Fiona has attended:
Excel Intermediate course
Excel
I want to attach RAG (Red/Amber/Gree) status to one of my spreadsheets - how best do I do this?
For upcoming training course dates see: Pricing & availability
RE: Excel
Hello Fiona,
Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.
Thank you for your question regarding attaching a Red/Amber/Green status to data in a spreadsheet.
This is done with Conditional Formatting.
Select the column of data that requires highlighting then click the Conditional Formatting button in the 'Styles' section of the 'Home' ribbon go to 'Icon Sets' and click on the 'Traffic Lights' set.
You may wish to edit how this is shown by again clicking on the Conditional Formatting button then selecting 'Manage Rule' then click 'Edit Rule'. Here you can make changes to how the formatting rule is applied to the data you have selected.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Fri 26 Nov 2010: Automatically marked as resolved.
|