I'd like to employ some conditional formatting based on the created date/age and priority ranking (0, 1, 2, 3) of a line item. Where a line item = work assignment. The goal being a health assessment visualization on the age and priority of work assignments.
Something like:
If WORK_ASSIGNMENT_CREATION_DATE is between 7 and 14 days ago and PRIORITY_RANKING is 0, return "green". If WORK_ASSIGNMENT_CREATION_DATE is between 15 and 30 days ago and PRIORITY_RANKING is 0, return "yellow". If WORK_ASSIGNMENT_CREATION_DATE is between 31 and 45 days ago and PRIORITY_RANKING is 0, return "red".
Where WORK_ASSIGNMENT_CREATION_DATE=Date in A1
and
PRIORITY_RANKING=0, 1, 2 or 3 in B1
Many thanks.
Bookmarks