Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007

Excel 2007

ResolvedVersion 2007

Tue 25 Nov 2008, 16:16 Delegate 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:42 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Excel 2007

Excel 2007

RE: excel 2007

Excel articles

Excel tip:

Display pictures on Chart Data Point