+ Reply to Thread
Results 1 to 2 of 2

Domino Effect Trigger Calculation

  1. #1
    Registered User
    Join Date
    01-29-2020
    Location
    Washington
    MS-Off Ver
    Excel 2016
    Posts
    1

    Post Domino Effect Trigger Calculation

    Hello Everyone,

    Here is a challenge that I'm still trying to figure out how to set the formula and I'm in need of your help

    So here is the background. Need to create a spreadsheet the each column's date triggers the next column if "date" has not been input it yet, for example.

    If "Start Date" is greater than (10 days) "Step 1" then trigger cell to changed color but ones date is added to the cell, then return to normal color.

    Now, with "Step 1" date in place, I also need to create a similar calculation for "Step 2" but with 30 day difference and same for "Step 3" and so on...

    I tried to used Conditional Formatting but seems that I can't get it through there.

    Please help!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Domino Effect Trigger Calculation

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ 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] VBA Script not getting trigger for automatic calculation
    By Neilesh Kumar in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-28-2018, 12:47 AM
  2. Automatically Select Lotus Domino Reference
    By vc027708 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2012, 01:51 PM
  3. Updating External DDE Tables Using a Manual Calculation Trigger Mechanism
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2011, 05:06 PM
  4. Run-Up Analysis & Commission Trigger Calculation
    By Vlad111 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2008, 09:39 AM
  5. [SOLVED] MOREFUNC.XLL - RECALL() to trigger once only calculation?
    By rhay999 in forum Excel General
    Replies: 0
    Last Post: 10-16-2005, 03:05 PM
  6. [SOLVED] how fill adatabasein domino designer with information of excel
    By zoy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2005, 05:06 PM
  7. [SOLVED] Lotus domino form to excel
    By in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2005, 11:06 AM

Tags for this Thread

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