Hi,
I'd like to highlight tasks (specifically the Start date cell) a color when that date is less than the current date (today) and Completion is 0% or null. In other words, which tasks were supposed to start but have not yet started. I realize this is a complex condition that uses two fields but it would be helpful as a PM tool.
SS doesn't seem to allow a date condition to be defined using the current date. Meaning, it should recognize today's datestamp as part of the condition and not require me to enter a specific date as a new condition every time I want to run it.
Similarly, this would be helpful to apply to Finish dates that are less than the current date.
Am I missing something? If not, this seems to be an enhancement opportunity.
Thanks.