+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting IF Function to identify past due items in red and items completed

  1. #1
    Registered User
    Join Date
    08-13-2014
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    1

    Talking Conditional Formatting IF Function to identify past due items in red and items completed

    Hello,

    I have a spreadsheet that lists a set of actions and the days they need to be completed.

    The due dates are listed in column c and in column h I have a the user choosing "completed" from a drop down data validation.

    I have a dashboard on a separate worksheet, showing if the item is complete and the due date.

    Ideally I would like to display the dates on the dashboard in red if they are past due, and the box in column h was not marked complete.

    I have been going through my books and trying to solve this, but I run into a different issues.

    Even if for now If I can get the main worksheet to display the color conditional formatting that would work

    I am excited to find this forum and look forward to going through it and participating.

    Thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Conditional Formatting IF Function to identify past due items in red and items complet

    Use formula based conditional formatting.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Conditional Formatting IF Function to identify past due items in red and items complet

    Why cant you set conditional formatting based on the value from the completed box?

+ 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. Move Completed Items to a new worksheet.
    By Linzela42300 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2013, 01:48 PM
  2. gray out and move completed items to different worksheet
    By kirstenpolley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2012, 01:28 PM
  3. Identify Items, Sort those Items, Copy the Items
    By a1981stingray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2010, 10:50 AM
  4. Conditional Formatting for Items Past Due
    By Nilreveb in forum Excel General
    Replies: 2
    Last Post: 07-23-2009, 04:17 PM
  5. [SOLVED] I would like to use conditional formatting for 4 or more items.
    By Inge in forum Excel General
    Replies: 3
    Last Post: 08-22-2006, 07:30 PM

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