+ Reply to Thread
Results 1 to 4 of 4

a cell changing colour base on date comparion

  1. #1
    Registered User
    Join Date
    03-11-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    25

    a cell changing colour base on date comparion

    can some help me write a macro for a cell changing color from green to yellow to red base on completion date?

    -Display green if status 'not started' or 'commenced' with due date equal to or greater than 30 days prior to todays date

    -Display yellow if status 'not started' or 'commenced' with due date less than 30 days prior to todays date or, equal to todays date

    -Display red if status 'not started' or 'commenced' with due date greater than todays date

    -Display green if status equals completed

    Thanks in advance

    regards
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: a cell changing colour base on date comparion

    check this:
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-11-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: a cell changing colour base on date comparion

    i cant see any VBA script ?

  4. #4
    Registered User
    Join Date
    03-11-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: a cell changing colour base on date comparion

    someone can help me on this ? thx alot

+ Reply to Thread

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