I need to know how to colorize a preexisting deadline column based on the following criteria. I have some suggestions for how to do it using a new dedicated column which does work but I really need to colorize the preexisting column.
red if overdue by 1 day or more
dark orange if due today or tomorrow
light orange if due in 2-7 days
green if due in more than 7 days
Assistance is greatly appreciated.