Consulting

Results 1 to 8 of 8

Thread: Can this Conditional Formatting Code be simplified

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    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.
    Attached Files Attached Files
    Last edited by LutonBarry; 05-21-2016 at 01:24 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •