Conditional Formatting Date Range

sarah_specialized

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.

Matt Johnson

Hi @sarah_specialized

I'm sure there's a better way to do this with a checkbox helper column and a formula but these (3) conditional formats stacked up seem to work too.

I hope that helps...and works.

Matt