Conditional Format cells based on date in another cell

Options
DawnS
DawnS
edited 12/09/19 in Smartsheet Basics

Hi - I am new to the community and have searched the discussions on conditional format but couldn't find what I am looking for.  I have a sheet that will have approx 20 cols containing scheduled and actual dates for various activities.  I would like to conditionally format the actual date field to set it red if it is greater than the scheduled date.  I know I can set up a status field and use formula to compare, but as I have in excess of 10 sets of dates to compare, I would like to do this directly in the date field using conditional formatting.  Has anyone been able to do this?  Many thanks, Dawn

Comments