Conditional Formatting Date Range

Options

Hi! I am trying to conditionally format a row if the date range of Start and Finish columns contains today's date. In the example below, I would like "Pilot Run Material Prep" to automatically highlight and for it to adjust as we move through a project. It seems I can only conditionally format the Start column for a certain number of days from today or if Start is today, but that doesn't work because the task ranges are variable.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!