Deadline Formula

Hi, new to this forum so thanks in advance for any help you can give

I am not the most advanced user of Excel and IF functions etc.. have gone from my memory since college work

I am currently working on a process using Excel to highlight cells etc depending on dates

I would like to create a conditional formatting rule that highlights a cell (D5) when it becomes 7 days from the date of input (Cell A5)

If the date does become 7 days after the date of input text saying 'Yes' would be needed to be put in cell H5

However, this highlighting can be stopped if another cell (F5) has text containing 'Yes' and cell H5 text can be changed to 'No'

Thank you for any help any of you can offer

Regards

Rob

cell D5 to become highlighted

Formula:

Please Login or Register  to view this content.

cell H5 to say 'Yes'

Formula:

Please Login or Register  to view this content.

Place the cursor in D5 cell and extend the selection below and in conditional formatting formula use the below formula

Formula:

Please Login or Register  to view this content.

In H5 cell

Formula:

Please Login or Register  to view this content.

Hi RobPreston1993

In H5: =IF(OR($F5={"No",""}),"Yes","")

And for the Conditional formatting > Home Tab > New Rule > Use a Formula etc: =D5<TODAY()