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
As Sam_w says, conditional formatting.
Please don't colour any other columns though. I may get project PTSD.
1 Attachment
I have no use for the colour I however have an MD who likes red/green and he both pays me monthly and hopefully pays my bonus so red/green it is.
Coloured in spreadsheets are the bane of my life. Along with merged column headers....
@NotThamesWater 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