Results 1 to 6 of 6

Automated colour fill based on dates PROBLEM

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2010
    Location
    Blackpool, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Automated colour fill based on dates PROBLEM

    I need some assisstant with a problem it have at work. I have a column J named Resolution date and column M which is a indicater and column N closure date.

    This is the way i need it to work.

    If the closure date is four days or more over the resolution date i want column M box to turn red.

    If the closure date is 1 to 3 days over i want column M to turn amber.

    If the closure date is the same as the Resolution date i want it to be Green.

    I Hope this makes sense.

    If anyone could help me with this Problem i would appreciate it alot
    Last edited by MFlo85; 10-08-2010 at 06:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1