Results 1 to 4 of 4

conditional format based on dates.

Threaded View

11ktran44 conditional format based on... 03-24-2014, 05:51 PM
etaf Re: conditional format based... 03-24-2014, 06:06 PM
11ktran44 Re: conditional format based... 03-26-2014, 12:41 PM
etaf Re: conditional format based... 03-26-2014, 12:55 PM
  1. #1
    Registered User
    Join Date
    08-14-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    43

    conditional format based on dates.

    Hello All,

    I set conditional format the cell highilighted when C2>B2+2. C2 is the date assigned, B2 is the completed date. The problem I have is that it counts weekend. for example, assignment date 3/21 is Friday and completed date is 3/24 on monday. It should not be highlighted becuase it is actually only 1 working day. Can someone help me with this please?

    Thanks in advanced.
    KAT
    Last edited by 11ktran44; 03-26-2014 at 12:39 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Format Cell based on Dates in Other Cells
    By kortekn in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-21-2013, 11:50 AM
  2. Conditional format between dates based on today()
    By StevieNix in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-27-2012, 06:06 PM
  3. Replies: 0
    Last Post: 05-20-2011, 02:33 PM
  4. Conditional format dates
    By Mrs.Z in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2011, 12:51 PM
  5. Conditional Format Dates in a Calender when Matches dates in a list
    By Lungfish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2009, 06:23 AM

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