In Google Sheets I am trying to use conditional formatting to change the format of a column of cells if the date in that column it more that 14 days before today, AND if a separate column is blank.

This is what I have so far, but it doesn't work.

Fore the specific range I want: C2:C287

Custom Formula:

=TODAY()-14 =AND =ISBLANK(L2:L287)

Any help would be greatly appreciated.

With C2:C287 selected, try this as the custom CF formula:

=AND(C2<TODAY()-14,ISBLANK(L2))

Conditional formatting rules only need the first cell in the range (and any relative ranges) in order to extrapolate the relationship to every other cell in the range.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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