Hi All,
I would like to format a project tracker that I have set up on excel.
I have a Deadline/Due date column which gives the date the project needs to be completed by (Column J) and I have a percentage column of an estimated % of how far along the project is (Column M)
What I would like my spreadsheet to do is:
Highlight the date in column J red when the date passes AND the percentage in column M is less than 100%
Not highlight the date if the percentage in column M is 100% and the deadline date in column J has passed
Not highlight the date if the percentage in column M less than 100% and the deadline date in column J has not yet passed
Can anyone help me with this? I have tried everything I can think of and searched numerous posts!
TIA
Bookmarks