Date Comparison to Highlight Cells

[DanA1509]

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

 

[DanA1509]

Update:

I have the idea for the statement, but don't know how it needs to be stuctured to create the result.

if (closed date[K#] is empty, then check if(deadline[D#] < dateserial(year(now()), month(now()), day(now()-15)), then highlight cell

I don't know if the way I've explained it there makes sense, and if people want me to better explain it I will try.

 

[DanA1509]

The issue has since been sorted by using the formula

=AND(K4="",D6 < NOW())

in the forumla highlight cell