+ Reply to Thread
Results 1 to 3 of 3

changing colors on columns and showing EXPIRED when 0 is reached

Hybrid View

  1. 08-22-2011, 08:18 PM #1
    SAM1979
    SAM1979 is offline
    Registered User
    Join Date
    08-19-2011
    Location
    copperas cove, tx
    MS-Off Ver
    Excel 2003
    Posts
    9

    Unhappy changing colors on columns and showing EXPIRED when 0 is reached

    I have a spreadsheet attached what I am trying to do is

    I2-DAYS TO RENEW
    I would like it to be GREEN TILL 180 DAYS

    At 179 days would like it to turn YELLOW

    at 90 days turn RED

    when at 0 would like it to say EXPIRED and be able to turn A2-A3(LAST NAME, FIRST NAME) RED when EXPIRED is reached.I have attached what I have so far. I told my boss I could do this and I think I am in over my head any help is greatly appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-22-2011, 08:55 PM #2
    tigertiger
    tigertiger is offline
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: changing colors on columns and showing EXPIRED when 0 is reached

    Try a solution,

    Using conditional formatting
    and recreate the formula for cell at column I (I2,I3,...)

    See the attached file
    Attached Files Attached Files
    Best regard, -)iger-/iger
    If you are pleased with a solution mark your post SOLVED.
    Reply With QuoteRegister To Reply
  3. 08-23-2011, 09:48 AM #3
    SAM1979
    SAM1979 is offline
    Registered User
    Join Date
    08-19-2011
    Location
    copperas cove, tx
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: changing colors on columns and showing EXPIRED when 0 is reached

    woo hoooo you my friend have made my boss a happy camper thanks a million
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1