Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting
|
|
|
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. |
Conditional Formatting
Resolved · High Priority · Version 2007
Reply Tue 22 Feb 2011, 16:52Delegate Svetlana said...
Svetlana has attended:
Excel Intermediate course
Conditional Formatting
Hi,
I have a table with different data and one of the columns is names of countries. I am trying to filter this column by different countries and highlight each country in a different colour. I can do it manually one country after another. However, could I actually apply conditional formatting using names of the countries, rather than data?
Many thanks,
Svetlana
For upcoming training course dates see: Pricing & availability
RE: Conditional Formatting
Hello Svetlana,
Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.
Thank you for your question regarding conditional formatting.
In order to do this first select the data for the country column then click the 'Conditional Formatting' button on the 'Home' ribbon. Enter the country name and select custom format and choose your own fill colour and font colour. You have to do this for each country which can take a while if you have many of them in your list.
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
|