+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : I cant auto change a date colour referanced to todays date

  1. 05-16-2011, 07:31 PM #1
    donjjjordan
    donjjjordan is offline
    Registered User
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    16.45
    Posts
    35

    I cant auto change a date colour referanced to todays date

    I have spent three days on this now and its doing my head in, I have three dates
    chasing date (B3)
    Due date (B4)
    Today's date (B5)
    i want B3 to change green 7 days leading to B4 and change red after B4
    attached is the problem i am trying to solve
    Attached Files Attached Files
    Last edited by donjjjordan; 05-17-2011 at 09:25 AM.
    Reply With QuoteRegister To Reply
  2. 05-17-2011, 09:12 AM #2
    Cutter
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: I cant auto change a date colour referanced to todays date

    Try the attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 05-17-2011, 09:24 AM #3
    donjjjordan
    donjjjordan is offline
    Registered User
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    16.45
    Posts
    35

    Re: I cant auto change a date colour referanced to todays date

    You are a star thank you so much, i really do appreciate your help
    Reply With QuoteRegister To Reply
  4. 05-17-2011, 09:44 AM #4
    Cutter
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: I cant auto change a date colour referanced to todays date

    You're welcome.
    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