In Column N I have the "SLA End Date"
In Column I, is the priority.
I need a Conditional Format statement (based on NETWORKDAYS
1 (same-day SLA)
2 (3-day SLA)
3 (6-day SLA)
No SLA
I need columns B to H in that row to turn a specific colour based on the following (I can obviously set the colour to appropriate, but just putting it down to show the difference in what I hopefully can get as my end request!
Dark Red - Over SLA End Date
Orange - Within one working day of End of SLA Date
Yellow - Within 2 working days of End of SLA Date
Green - 3 or more working days of End of SLA Date
No Colour - No SLA Date provided
The current formula (which was based on old SLAs and has somewhat broken the tracker as the referenced cells also seem wrong is
and the referenced cells are
In Column I, is the priority.
I need a Conditional Format statement (based on NETWORKDAYS
1 (same-day SLA)
2 (3-day SLA)
3 (6-day SLA)
No SLA
I need columns B to H in that row to turn a specific colour based on the following (I can obviously set the colour to appropriate, but just putting it down to show the difference in what I hopefully can get as my end request!
Dark Red - Over SLA End Date
Orange - Within one working day of End of SLA Date
Yellow - Within 2 working days of End of SLA Date
Green - 3 or more working days of End of SLA Date
No Colour - No SLA Date provided
The current formula (which was based on old SLAs and has somewhat broken the tracker as the referenced cells also seem wrong is
Excel Formula:
=AND(NETWORKDAYS(TODAY(),$N2)>2,NETWORKDAYS(TODAY(),$N2)<=4)
Excel Formula:
=$B$2:$H$3,$B$5:$E$5,$G$5:$H$5,$B$36:$H$36