Enable conditional formatting based on Critical Path items

Julian Sindall

When a row is on the critical path, I'd like to be able to set conditional formatting so that it turns text red, or colours the cells, so that it is a more obvious visual cue that this task is a particularly important one.

Genevieve P.

Hey @Julian Sindall

You can use the function ISCRITICAL to identify if a row is on the Critical Path or not. For example:

=IF(ISCRITICAL([Task Name]@row), "Yes", "No")

Then once you have this in the grid of your sheet, you can set a Conditional Formatting rule based on that formula column!

Cheers,

Genevieve

Julian Sindall

Thank you - that's a useful workaround. I'll use that. Obviously it would be more data efficient to be able to conditional format directly, but this will do in the meantime :-)

CBT

I like the conditional formatting based on critical path, but I would love to see the rows of the grid that correspond to the gantt bars highlight when you select to show critical path or show summary path.