Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    [SOLVED] Checking overdue date value from cell

    Hey all,

    Have been working on a spreadsheet that is slowly evolving, and was hoping i could extract information to make it even more automated, so to speak.

    Currently, i receive 1 worksheet 2-3 times a week (quantities change regularly), that outlines upto 8 different models (all on the same sheet) with quantities either sent, due to arrive, or in production. For each model, I have the (sent items - color coded blue), (stock due - colored yellow) and the (stock in production - clear). I want to modify this worksheet which will take the information for each model, and was hoping to set it up that when the "Promise date" was more than 14 days, it would highlight (maybe add another column for overdue) red to make it easier for a visual over the sheet.

    Appreciate any help.

    Regards
    Rob

    Book1.xlsx
    Last edited by robsanders; 2012-09-24 at 19:02.

  2. #2
    New Lounger
    Join Date
    Sep 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Have had some help from another forum, but thought it would be good to share.

    Using conditional formatting. high-light the range you want (E2:E9?), on the home ribbon, select CF, select "format only cells", select "cells" (this should be the default anyway), select "less than" from the next pull-down, in the next empty boxe, enter =TODAY()-14. select "format" and select the fill you want, then enter twice. this will high-light all dates that are 14 days older than todays date.
    Was hoping there was way to only "check" this criteria to those cells that are not already colored green, blue or yellow. That is, only to apply to those cells that are clear (in manufacturing) ?

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Cross-posted at http://www.excelguru.ca/forums/showt...ing-and-totals and also at http://www.excelforum.com/excel-gene...096&viewfull=1

    I would recommend any response stay in the 2nd cross-post since that is the one with an active conversation and not continue with 3 conversations.

    Rob, You may want to also look at http://www.excelguru.ca/content.php?184

    Steve

  4. #4
    New Lounger
    Join Date
    Sep 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Fair point.

    Shall continue with the active forum from here on.

Posting Permissions

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