Skip to main content
Web Applications

Return to Question

removed tag from title
Link
ale
ale
  • 52.9k
  • 42
  • 165
  • 314

Google Sheets - Conditional Formatting Based on Date Formula

removed noise; retagged with appropriate tags; fixed formatting
Source Link
ale
ale
  • 52.9k
  • 42
  • 165
  • 314

I'm trying to highlight the contents of a Date cell if the following conditions are met:

  1. Value of another cell = "No"; and
  2. Value of target cell + 7 days > Today

The formula that I have right now is: =If(And((E2+7)>Today(),H2="No"))

Any help you can provide is appreciated thank you.=If(And((E2+7)>Today(),H2="No"))

I'm trying to highlight the contents of a Date cell if the following conditions are met:

  1. Value of another cell = "No"; and
  2. Value of target cell + 7 days > Today

The formula that I have right now is: =If(And((E2+7)>Today(),H2="No"))

Any help you can provide is appreciated thank you.

I'm trying to highlight the contents of a Date cell if the following conditions are met:

  1. Value of another cell = "No"; and
  2. Value of target cell + 7 days > Today

The formula that I have right now is: =If(And((E2+7)>Today(),H2="No"))

Source Link
user114695
user114695
  • 21
  • 1

Google Sheets - Conditional Formatting Based on Date Formula

I'm trying to highlight the contents of a Date cell if the following conditions are met:

  1. Value of another cell = "No"; and
  2. Value of target cell + 7 days > Today

The formula that I have right now is: =If(And((E2+7)>Today(),H2="No"))

Any help you can provide is appreciated thank you.