Can this Conditional Formatting Code be simplified
Hello I have code in the workbook attached that colours the rows based on the Call type Service Request or Incident (Column J) including the variations within them Incident-1, Incident-4 for example based on the urgency of the call and also time elasped into the SLA (column Z). So some rows will be red, some Amber and some Green.
I have written the code in two modules for Incidents and Service Requests and while it works OK I do wonder if it can be simplified and made quicker.
Last edited by LutonBarry; 05-21-2016 at 01:24 PM.