+ Reply to Thread
Results 1 to 3 of 3

Tracking order dates.

  1. #1
    Registered User
    Join Date
    04-28-2021
    Location
    Johannesburg
    MS-Off Ver
    365
    Posts
    2

    Tracking order dates.

    My question seems simple but so far nobody can solve it. Column A is date ordered. Column B is date that the order is expected to arrive-this has been programmed for 3 weeks after date ordered. I need 2 things please. First if the expected date arrives, the cell must highlight automatically (conditional formatting). This will flag me to follow up late orders.
    Second, if I check the check-box in Column C, it must override or reverse the conditional formatting of Column B, because by checking the box, it means that the order has arrived. Hope I've explained this properly.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Tracking order dates.

    I don't like check boxes for just this reason, they hover above the cell and are difficult to use in Conditional Formatting.
    Here's what I did. I selected each check box and went to its properties and "cell Link" and put in $C$5 (for the first one). I think this has to be done one at a time or maybe someone can develop a macro.
    Then I selected C5:C8 and formatted the font to be white (aka invisible)

    Conditional Formatting: Selected A5:B8: New Rule> Use Formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    formatted cell as desired.
    See Attachment
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    04-28-2021
    Location
    Johannesburg
    MS-Off Ver
    365
    Posts
    2

    Re: Tracking order dates.

    Problem solved, thank you very much.

+ 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. work order tracking
    By malaksalama in forum Excel General
    Replies: 1
    Last Post: 04-28-2020, 05:46 PM
  2. [SOLVED] Trouble with various formulas for order tracking
    By Klea in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-30-2018, 11:17 AM
  3. [SOLVED] Change Order Approval Tracking
    By Rhyno86 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-13-2015, 03:46 PM
  4. Work Order Tracking
    By BigF'inG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2014, 05:18 AM
  5. Help me build an order tracking worksheet
    By brianlg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2014, 11:23 PM
  6. COUNTIF for Re-order Tracking
    By n_navock in forum Excel General
    Replies: 1
    Last Post: 09-16-2010, 09:57 PM
  7. Tracking inventory order history
    By rjez in forum Excel General
    Replies: 1
    Last Post: 07-13-2006, 07:40 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