Hi,
I'm relatively new to Excel, but I'm currently working for a construction company in planning the start and finish dates, and just general progress for their construction projects.
I'm currently working off of very basic spreadsheets, where everything is entered manually. I know I could use Project, but I don't have the time at the moment to use it.
Anyway, my problem (and it's probably a relatively basic one) is:
I want to be able to enter the planned start and finish dates, and have the spreadsheet automatically change the colour of the cell to yellow when we get within a week of the due date, and maybe go red when it's overdue.
Also, when I enter the actual start/completion date in the following columns, is there a formula that would recognise that and change the colour of the planned start/finish dates back to no fill.
It's probably a very basic set-up, but as I said, I'm new to this.
Thanks,
Paddy
I'm relatively new to Excel, but I'm currently working for a construction company in planning the start and finish dates, and just general progress for their construction projects.
I'm currently working off of very basic spreadsheets, where everything is entered manually. I know I could use Project, but I don't have the time at the moment to use it.
Anyway, my problem (and it's probably a relatively basic one) is:
I want to be able to enter the planned start and finish dates, and have the spreadsheet automatically change the colour of the cell to yellow when we get within a week of the due date, and maybe go red when it's overdue.
Also, when I enter the actual start/completion date in the following columns, is there a formula that would recognise that and change the colour of the planned start/finish dates back to no fill.
It's probably a very basic set-up, but as I said, I'm new to this.
Thanks,
Paddy
