I'm trying to highlight the contents of a Date cell if the following conditions are met:
- Value of another cell = "No"; and
- Value of target cell + 7 days > Today
The formula that I have right now is:
You're on the right track, just get rid of If: the custom formula should be
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.