The column AA will be based on two things…the date in AB and/or the current date.
The objective is to turn the cell in AA yellow, orange or red based on the proximity of the dates to either the current date or the submitted date in column AB.
Yellow – within 5 business days
Orange – within 2 business days
Red – late
If there is not an Actual Submission date in column AB I want it to use the current date when the file is opened to display the highlights. If there is a date in AB I want to use the actual date in AB compared to the date in AA.