Excel

Hello Fiona,

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

Thank you for your question regarding attaching a Red/Amber/Green status to data in a spreadsheet.

This is done with Conditional Formatting.

Select the column of data that requires highlighting then click the Conditional Formatting button in the 'Styles' section of the 'Home' ribbon go to 'Icon Sets' and click on the 'Traffic Lights' set.

You may wish to edit how this is shown by again clicking on the Conditional Formatting button then selecting 'Manage Rule' then click 'Edit Rule'. Here you can make changes to how the formatting rule is applied to the data you have selected.

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