+ Reply to Thread
Results 1 to 11 of 11

Conditional Formatting for Overdue Date on specific cells

  1. #1
    Forum Contributor
    Join Date
    08-20-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010, 2016, 2019
    Posts
    110

    Conditional Formatting for Overdue Date on specific cells

    Hi,

    I have created a Gantt Chart in excel to show various solutions, by using a combination of Conditional Formatting and Name Manager.

    I am now struggling with the Overdue date, as you will see on the workbook attached, it highlighted the whole row, I only want it to highlight the cells that is overdue after the Finish date.

    I am open for any suggestions
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Conditional Formatting for Overdue Date on specific cells

    Try the following CF
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-20-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010, 2016, 2019
    Posts
    110

    Re: Conditional Formatting for Overdue Date on specific cells

    Quote Originally Posted by Pepe Le Mokko View Post
    Try the following CF
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    It now highlights from today's date onwards. I would like it to only highlight today, and if the task is not complete tomorrow, then tomorrow as well, etc
    Attached Files Attached Files

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Conditional Formatting for Overdue Date on specific cells

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 10-05-2020 at 10:18 AM. Reason: Inserted commas

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Conditional Formatting for Overdue Date on specific cells

    Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

  6. #6
    Forum Contributor
    Join Date
    08-20-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010, 2016, 2019
    Posts
    110

    Re: Conditional Formatting for Overdue Date on specific cells

    The formula worked and only highlighted today's cell, the issue comes in if the percentage changes to 100%, the cell is still highlighted and if any other tasks are changed to overdue, it still only highlighted today's cell

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Conditional Formatting for Overdue Date on specific cells

    Any other conditions ?
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    08-20-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010, 2016, 2019
    Posts
    110

    Re: Conditional Formatting for Overdue Date on specific cells

    Still only highlight today's cell, not any other previous days

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Conditional Formatting for Overdue Date on specific cells

    As you don't even say a small "thank you" for the help already received ( for free), I'll leave it to others to try to understand your requirements.
    Good luck

  10. #10
    Forum Contributor
    Join Date
    08-20-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010, 2016, 2019
    Posts
    110

    Re: Conditional Formatting for Overdue Date on specific cells

    I am sorry you are having a bad day, but I appreciate the time you have spent trying to understand my requirements, thank you!

  11. #11
    Forum Contributor
    Join Date
    08-20-2013
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2010, 2016, 2019
    Posts
    110

    Re: Conditional Formatting for Overdue Date on specific cells

    Below formula worked

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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] Conditional Formatting Gantt Chart to show overdue date
    By guvy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2019, 09:25 AM
  2. [SOLVED] Conditional Formatting Gantt Chart to show overdue date
    By guvy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2019, 02:41 AM
  3. [SOLVED] Can't get overdue date conditional formatting to work
    By WarrenSA in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-09-2014, 10:33 AM
  4. Conditional Formatting a row that is overdue
    By Mikejbona in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2012, 06:06 PM
  5. Replies: 0
    Last Post: 04-10-2012, 11:56 AM
  6. Replies: 1
    Last Post: 02-02-2012, 04:06 AM
  7. [SOLVED] conditional formatting overdue dates
    By Joooooooo in forum Excel General
    Replies: 3
    Last Post: 02-08-2005, 09:24 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