i have a table
| case id |
severity |
open date |
status |
age |
| 3241765 |
critical |
6/5/2022 |
awaiting |
30 days |
| 9847636 |
high |
1/6/2022 |
pending |
5 days |
i want to highlight the table by queries like those:
if severity=critical AND status=awaiting or pending - highlight the values critical and awaiting in red
if severity=critical AND status=awaiting or pending more than 30 days- highlight the row in red
if case is open more then 30 days - mark the cell in red.
