![]() ![]() One column will show the actual date of review, the next will shown the scheduled review date and the next column will contain the traffic lights, Hi I am trying to create a spreadsheet using traffic lights in (2010) to show when a document review date has expired. This post in response to a comment Stephen wrote from an earlier post I wrote called How to format dates that are over 1 year old to turn red in Excel using conditional formatting. In this post, I’ll share how to set up traffic lights in Excel to show variances between a scheduled date and the actual date.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |