Condtional Formatting

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.

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