Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
added 6 characters in body; edited tags
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

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

Example: Column

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

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

I have dates in column D in Google Sheets. I want the cells to highlight to 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 a cell should turn red to alert me to follow up.

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.

Source Link
Joanne Gabriel
Joanne Gabriel
  • 19
  • 1

Google Sheets date conditional formatting

I have dates in column D in Google Sheets. I want the cells to highlight to 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 a cell should turn red to alert me to follow up.