Hightlight a record in a table using status and due date
Highlighting a record in a table. I want to highlight a record when a status is not equal to complete and the the due date is today or past.
Forum Discussion
Yeah I get where to do it. I need to know how to build the formula.
if ([Status] = "In Progress" and [Due Date] < Today(), "red", "")
The way it works is like this
IF("CONDITION" , "Result if True", "Result if False")
can also use hex colors, black is #00000 for example.
The way it works is like this
IF("CONDITION" , "Result if True", "Result if False")
can also use hex colors, black is #00000 for example.