Conditional Formating

24

I need help creating (2) condition in conditional formatting or a formulas that turns do the following;

• highlight all rows that are are between 3 and 5 days in the future from today's date
• highlight all rows that are more than 5 days in the future from today's date

Stefan

Hi,

what date are you referring to? Are there start and end dates in your rows?

Open the conditional formatting dialog, create a new rule and define the trigger to be if the date in the column "End date" is within the next 4 days. Then define your desired format and apply it to the whole row.

Same procedure for the second question.

To learn more have a look here:

https://help.smartsheet.com/learning-track/get-started/conditional-formatting

Hope this helps

Stefan