Results 1 to 3 of 3

Conditional Formatting - Due Dates

Threaded View

  1. #1
    Registered User
    Join Date
    09-18-2013
    Location
    Tarlac, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    4

    Conditional Formatting - Due Dates

    Hello everyone, my boss told me to make a control board which determines the due dates.
    If the it is 5 days before due date the text color will be green.
    If 3 days before the text color will be yellow.
    If it is in due date or overdue, the text color will be red.

    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting with approaching due dates and completed dates
    By rogernation in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-13-2013, 04:12 PM
  2. Replies: 4
    Last Post: 08-29-2013, 11:23 AM
  3. [SOLVED] Conditional Formatting of: dates within 1 month and dates before today.
    By Luke Smith in forum Excel General
    Replies: 5
    Last Post: 06-18-2013, 07:29 AM
  4. [SOLVED] Conditional formatting for due dates
    By Jimre123 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-13-2013, 03:27 PM
  5. [SOLVED] Conditional Formatting - Due Dates
    By clicky555 in forum Excel General
    Replies: 5
    Last Post: 08-02-2012, 05:51 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