Google Sheets date conditional formatting

Question

I have dates in column D in Google Sheets. I want the cells to highlight red if 30 days have passed and there is not a comment date in column F.

Example:

Column D: Submittal Date 6/29/2019
Column F: Comments Received (date)

If I don't receive comments within 30 days of submittal date the cell should turn red to alert me to follow up.

user0 · Accepted Answer · 2019-07-16 17:43:03Z

1

=IF((NOT(D1>TODAY()-30)) * (F1="") * (D1<>""), 1)

answered Jul 16, 2019 at 17:43

user0

27.1k10 gold badges53 silver badges78 bronze badges

1

Wonderful - thank you very much the quick response - it works like a charm!
– Joanne Gabriel
Commented Jul 16, 2019 at 17:54
1

@JoanneGabriel you are free to not accept the answer if it helped you solve your issue
– user0
Commented Jul 16, 2019 at 18:03

Add a comment |

1 Answer 1