CODEWITHSUNDEEP
dategoogle-sheetsconditional-formatting
Ruth
Ruth

Reputation: 5

Conditional Formatting Formula AND Date in Google Sheets

I need a column to turn red if today's date is 1 day before Ship Date and another column is not marked Shipped.

I've tried having the TODAY formula in an off sheet cell and reference it but I don't know how to get the Custom formula in Conditional Formatting to get AND to work correctly. I tried just to highlight if it was just set to "Ordered" but that didn't even work.

enter image description here

Upvotes: 0

Views: 32

Answers (1)

Harun24hr
Harun24hr

Reputation: 37125

Try custom CF rule.

=AND($B1=TODAY()-1,$A1="Shipped")

enter image description here

Upvotes: 0

Related Questions