Does anyone know of a function to set a square as a colour if a date is passed and another square has not been changed to completed?
Basically if the status is not updated as completed by the end date on track shows as Red
1 Attachment
Should be able to do this using the formula function within conditional formatting.
As Sam_w says, conditional formatting.
Please don't colour any other columns though. I may get project PTSD.
@SomethingOrOther started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Does anyone know of a function to set a square as a colour if a date is passed and another square has not been changed to completed?
Basically if the status is not updated as completed by the end date on track shows as Red
1 Attachment