Hi,

I'm new to this forum. I've been teaching myself formulas for work and I'm having trouble with a conditianal fomatting formula that I would really appreciate some help with. I'm using MS Excel 2010.

I've column O which has a date when information is received. Column P is the date this information is assessed.

I would like the date text in column O to turn red when 14 days has passed, and the information does not appear to have have been assesed (i.e. no date has been entered.

I've tried a couple of formulas, but they go red even when the date entered in Column O is either todays date, or not exceeded 14 days.

The formulas I've tried so far are:

=AND($O2<=o2+14,$P2="")

=IF(AND($O2>1/1/1900,O2+14),$P2="")

As I said before, I'm really new to this and I feel like I'm back at school trying to do algebra again (which I didn't like), so I apologies if there looks to be any stupid or obvious mistakes. I really is a case of trial and error for me.

Any help would be greatly appreciated.

Kind Regards

Sarah