Conditional Formatting based on the status of Predecessors / Dependencies
I'm looking to use Smartsheet to track the overall status of our software development team's progress. I'd like to be able to quickly identify any tasks in a list that are blocking other tasks from being completed.
For example, a task on say row 11 is dependent on row 2. Row 11 has a status of 'blocked' because of some outstanding work required to complete row 2. I'd like to highlight row 2 in a different colour in order to draw attention to the fact that it is blocking other work.
How might I achieve this?