How do we make a due date stand out if it is less than 30-days away on a Microsoft Spreadsheet?
Posted on 2014-09-04
We have a spreadsheet that lists the jobs that are pending. It shows the title, due date, if completed Y/N, who is working on the project, etc. What we would like is for the "Due Date" to turn from black to "BOLD" "RED", and "BLINK" whenever the listing is shown on the screen or printed. When the field that indicates the the job has been completed with "Y" or a "completion Date is entered, the DUE DATE will return to its normal appearance.
Any suggestions that you can give will be appreciated.