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
- Do you want this on a report or a form?
- Report.
- Go to the report settings. Should be at the bottom
https://login.quickbase.com/user-assi... - 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. - Chuck, thanks what if its if status does not equal and due date
- I ask because I have five statuses and we don't want to highlight the completed records
