In a previous post, I had a formula that would calculate if a date was “overdue”, ie, 7 days from starting date, and display the word “Overdue” in a separate field. It’s working.
I’m wondering though, is there a way to have the field, Starting Date, change colour if a condition is met? In other words, if that date is now overdue, it changes to red.
There’s no function for that. Numbers have a “Highlight negative numbers” option on them, but it’s just for that field, which will show in red.
.
