![]() Green if carried out before or on the scheduled review date,Īmber if between 1 and 30 days overdue andĪt the time of review the actual date column will then be updated to reflect the new date. 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 |