Condtional Formatting

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

Can you send the file please.

Sorry, I can't as it is a work file.

OK, I've managed to add two by mistake and I can't work out how to delete 1. The 31kb should be used.

Column F has the date the response is received. As this is exceeds 14 days and it does not appear to have been assessed (no date in column F), I would like the date text to turn red.

I hope this helps.

Any cell blank in column F or if it is greater than Column B+14 it will be red

Sorry you need to turn the calculations back to automatic.

Thanks, but you looked at the incorrect file. It was my fault as I added both in error.

On the one I've attached again below, Column F has the date the response is received. As this is exceeds 14 days and it does not appear to have been assessed (no date in column G), I would like the date text (in column F) to turn red.

I don't want the cell in column G to turn red.

The date in column F would then return to black once a date is added into column G.

I hope this makes sense.

Hi Sarah,

The attached will do what you want.

1.) If no entry in column G then the text in column F turns to red
2.) If Column F date > Column B +14 then text turns to red
2.) If there is an entry in G regardless what is the value in column F the text in column F turns to black

Thank you, I appreciate this.

I'm not worried about the dates in column B as I have those already worked out, it was just the Colum F dates being +14.

+14 of what?

If you mean +14 of today then in condition 3 change =$B4+14 to =Today()+14

I'm obviously not very good at explaining myself, so I apologise for that.

I've removed all the other columns now to avoid confusion. I'd managed to sort out the formulas I needed for those.

What I would like is if there is a date in the information received column, this should turn red if 14 days have elapsed and it looks as if no-one has it assessed it (information assessed column has no date. I'm only after the text turning red, not the cell.
Once a date has been entered in the information assessed cell, the date in the previous column would return back to black.

I really hope this makes sense.

Summary - Informaition received more than 14 days ago, not assessed - date turns red. Once asessed, date returns back to black.

the file I sent earlier, in condition 3 change =$B4+14 to =Today()-14 and this will do what you need.