excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th, 12th Nov 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Excel

resolvedResolved · Medium Priority · Version 2003

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.

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

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

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.



Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.



To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.