Generate Date + Conditional formatting in a table

Hello!

I have three columns in question: Editorial Due Date, Shipping Date, Editing Status. I am trying to do the following:

Automatically populate the Editorial Due Date to equal Shipping Date + 4 months
Create conditional formatting for the Editorial Due Date:

I am also trying to conditionally format the Editorial Due Date and can’t seem to find the right formula(s):

If the Editing Status is NOT Done AND less than 30 days until due date, it turns yellow
If the Editing Status is NOT Done AND less than 14 days until due date, it turns orange
If the Editing Status is NOT Done AND less than 7 days until due date, it turns red

I feel like such a ding dong! When I try to use the Date features, I can’t seem to get it to work.

Thanks so much for your help!

All you need to do is to setup Condition for this so that you will get all what you are looking to get

Thanks! I attempted to find the setup condition that combines the two (ie through the standard conditional format options); however, none of them allow for two variables (unless I use a formula, which I’m trying to figure out).

You will have to make use of both formula and conditional format, this is the formula
Screenshot 2024-05-22 001335

This is your condition format

I just create this now , if you are still facing any issue with this let me know