98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007
Excel 2007
Resolved · Low Priority · Version 2007
Tue 25 Nov 2008, 16:16Delegate Sophie said...
Sophie has attended:
Excel Intermediate course
Excel 2007
how can I give a different colour to eg/ each city in a list of text?
Wed 17 Dec 2008, 10:42Trainer Mark said...
RE: excel 2007
Hi Sophie
Thanks for the post, sorry i haven't got back to you sooner
I have looked in to this and all you need to do is re-apply the different condition to the column of text if this doesn't do the trick, then sort your data by city then do conditional formatting on the data
Hope this help
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
Tue 23 Dec 2008: Automatically marked as resolved.
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 tip:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |
