Hello
I have several columns in this spreadsheet and I would like to write a formula (conditional formatting) that would highlight a cell in column S if certain criteria is met.
Column S is the sale date column U is the date an email was sent and column AM is a yes or blank column.
So the conditional format I am trying to write the formula id for column S. I would like to highlight the cell if:
1. The date in column S plus 10 months is greater than the date in cell U1 and Column U and AM are blank.
2. In some cases a cell in column U can be blank while column AM is populated.
Any help would be appreciated.
I have several columns in this spreadsheet and I would like to write a formula (conditional formatting) that would highlight a cell in column S if certain criteria is met.
Column S is the sale date column U is the date an email was sent and column AM is a yes or blank column.
So the conditional format I am trying to write the formula id for column S. I would like to highlight the cell if:
1. The date in column S plus 10 months is greater than the date in cell U1 and Column U and AM are blank.
2. In some cases a cell in column U can be blank while column AM is populated.
Any help would be appreciated.