Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · Medium Priority · Version 2003

Reply Mon 31 Jan 2011, 11:46Delegate Alan said...

Alan has attended:
Excel Advanced course

Excel

In a table recording progress on a project, certain cells represent the status (in relation to a deadline) of particular actions. The status might red, amber/red, amber, amber/green or green.

By using Data / Validation I have created a list of of those options, but I would also like to colour the cells automatically with the relevant colour, instead of having to copy and paste each coloured infill from a range saved elsewhere in the worksheet. Is there a way to do that, please? Many thanks.

For upcoming training course dates see: Pricing & availability

Reply Mon 31 Jan 2011, 15:29Trainer Rodney said...

RE: Excel

Hello Alan,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding the use of Conditional Formatting. I have created a spreadsheet with some conditional formatting and data validation added in. Since I don't have a copy of your file to view I have used a sample file which may or may not answer your question.

Since you are using five different type of statuses you will not be able to use conditional formatting in Excel 2003 since the limitation is 3. You will have to cut down the colours to red, amber and green - then it will work as I have shown in my sample file.

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

Attached files...

Conditional formatting.xls

Mon 7 Feb 2011: Automatically marked as resolved.

Excel articles

· Creating Charts with Excel
· How To Get The Best Out Of Excel With The Internet
· Discover The Secret Of How To Conditionally Format An Excel Chart
· Using The Excel Forms Toolbar To Spruce Up A Workbook
· Discover The Difference Between Line And XY Scatter Charts In Excel

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips