Hi all –
My team is struggling how to quickly scan a list of tasks within a project and see which ones are active and ready to be worked on at a given time.
Is there a way to do this? Perhaps with Conditional Formating when creating a view?
Thanks in advance!
Yes, there are a couple of options
You may want to add 2 rules - first a rule for when a task is complete - then the rule for when a task can start
Otherwise all those tasks that were ready to start and are now complete, show the can start icon or color
Thanks @Heather_Kulbacki. This is exactly what I was trying to figure out.
Is there a way to determine the order the rules get applied in? For instance, first I built a rule to highlight active rows green on my Can Start column. Second I built a rule that turns the row grey once PercentComplete reaches 100%. The first rule seems to over rule the second. Is there somewhere to control that?
What it seems like to me - and I haven't tried to dig up any documentation, so I'm just guessing - it applies the first rule first and if that applies, it doesn't apply the second rule unless something changes and it looks at that task again.
So I think you'd want your PercentComplete = 100% rule first
You're correct, Heather, that conditional formatting rules are applied top to bottom.
@swoerle you could also apply the conditional formatting to the entire row or just to the cell you're focusing on.