+ Reply to Thread
Results 1 to 3 of 3

Have a field change color based on date of another field

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    7

    Have a field change color based on date of another field

    How do I have fields change color based on the date of another field?

    My Example:
    Site Visited - 7/5/16
    IRP Comments Due(15 days) - Projected date to submit comments by 7/20/16
    Corps Comments Due (30 days) - Projected date to submit comments by 8/4/16

    Based on the Site Visited - 7/5/16, I would like to have the IRP comments cell highlighted green until it reaches 10 days, after 10 days the cell would then highlight to yellow and after 15 days the cell would highlight red. For Corps comments the cell would be highlighted in green until it reaches 25 days past the original site visit, then it would turn yellow. After 30 days it would turn red.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,648

    Re: Have a field change color based on date of another field

    Hi,

    Have you tried conditional formats?

    Please explain what you mean by 'it reaches 10 days'. What's "It"? Is that the date to submit comments, the current date or what?

    It's always easier if you can upload an example workbook so that we can see in context. Manually add the colours you expect to see.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,391

    Re: Have a field change color based on date of another field

    You would do this with Conditional Formatting...
    1. highlight the range you want to apply the conditional formatting to
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =A1<=today()-10
    change A1 to suite

    Repeat 3 and 4 for >10
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] PowerPivot: Merge Month Field and Year Field Into a Date Field
    By mo4391 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-17-2015, 11:59 AM
  2. Replies: 4
    Last Post: 05-15-2015, 11:29 AM
  3. Change an existing field to a calculated field using Show Values as
    By Excel_vba in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 01:50 PM
  4. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  5. Change data based on date field
    By mtbe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2009, 08:25 AM
  6. Replies: 4
    Last Post: 07-11-2006, 01:35 PM
  7. [SOLVED] Q: assign field background color dynamically according to field values
    By Stephan Schnitzler in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-07-2005, 04:07 AM

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