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
Conditional formatting.xls
