+ Reply to Thread
Results 1 to 1 of 1

Clear column based on other column in a table and re-sort table

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    Canada
    MS-Off Ver
    Excel 2016
    Posts
    67

    Clear column based on other column in a table and re-sort table

    Screenshots attached, showing basic table idea is when column B has a date, column C shows days until that date based on A1 (which is just =TODAY()), and makes the row bold. When column D has a date, the row gets italicized, a strikethrough and font color change.

    1. How can I have column C (Days to Target) show no value or be cleared when I have inputted a Done Date (column D)
    2. Possible to have a rule sorting the table when a Done Date has been inputted, making completed task rows sit at the bottom?

    Thanks for any help!
    Attached Images Attached Images

+ 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. Clear content of all table but one column
    By simonplus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2017, 12:12 PM
  2. [SOLVED] Alpha Sort Table Column based on Criteria for Validation List
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2017, 04:13 PM
  3. [SOLVED] [ASK] how to solve column to row sort table by 3 column (A,B,C) ?
    By paoxiang in forum Excel General
    Replies: 4
    Last Post: 12-02-2014, 10:09 PM
  4. [SOLVED] Look at column in table, remove duplicates and sort to another table
    By pdx-adm-trm01 in forum Excel General
    Replies: 1
    Last Post: 03-19-2014, 06:56 PM
  5. [SOLVED] Sort pivot table based on first column entry
    By Derek Cavanagh in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-20-2013, 12:01 AM
  6. [SOLVED] Need a formula to sort a table into table (for a Table Plan) and name in column 2
    By jbpianoman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2012, 09:21 AM
  7. Sort pivot table based on column selected in another sheet
    By holmes123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 05:42 PM

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