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"))

1 Answer 1


You're on the right track, just get rid of If: the custom formula should be

=And((E2+7)>Today(), H2="No")


If requires at least two arguments: condition and the result to be returned. Here you just have a condition, so if is neither suitable nor needed. The formula used for conditional formatting should return a boolean value (True/False), or a numeric value, which will be coerced to boolean as follows: 0 will be interpreted as False, nonzero as True. The formatting is applied if the formula returns True.

In your case, and returns a boolean value, which is all you need.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.