Hi All,
I'm working on a job booking system and I'm looking to create an if statement to highlight cells that have gone past the expected finishing times.
In the 'D' collumn I have the date the job is expected to finish as DD/MM/YYYY, and in 'K' collumn I have a similar set up that people enter times when finished. Is it possible to highlight cells that are either blank or are greater than 2 weeks past the expected finish date in 'D' collumn?
Any and all help greatly appreciated,
All the best,
Dan
I'm working on a job booking system and I'm looking to create an if statement to highlight cells that have gone past the expected finishing times.
In the 'D' collumn I have the date the job is expected to finish as DD/MM/YYYY, and in 'K' collumn I have a similar set up that people enter times when finished. Is it possible to highlight cells that are either blank or are greater than 2 weeks past the expected finish date in 'D' collumn?
Any and all help greatly appreciated,
All the best,
Dan