Hi all,
I am creating a spreadsheet to track job progress. Each job has upto 8 different tasks.
For each task
I have 3 columns in a table named "Required", "Booked" and "complete"
Required will a yes/no from drop down box
booked and received will contain dates
I then have 8 columns in the table that I would like to indicate the status of each task by changing the fill coulour.
Task required - if no fill=grey
required but no booked date - red fill
required and booked date - yellow fill
completed date - green fill.
I have started using conditional formatting but I feel like there should be an easier way given the are 8 columns I would need to apply each condition to
Thank you in advance for your help
Dave
I am creating a spreadsheet to track job progress. Each job has upto 8 different tasks.
For each task
I have 3 columns in a table named "Required", "Booked" and "complete"
Required will a yes/no from drop down box
booked and received will contain dates
I then have 8 columns in the table that I would like to indicate the status of each task by changing the fill coulour.
Task required - if no fill=grey
required but no booked date - red fill
required and booked date - yellow fill
completed date - green fill.
I have started using conditional formatting but I feel like there should be an easier way given the are 8 columns I would need to apply each condition to
Thank you in advance for your help
Dave