+ Reply to Thread
Results 1 to 4 of 4

conditional format based on dates.

  1. 03-24-2014, 05:51 PM #1
    11ktran44
    11ktran44 is offline
    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.
    Reply With QuoteRegister To Reply
  2. 03-24-2014, 06:06 PM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,737

    Re: conditional format based on dates.

    try using
    =C2>WORKDAY(B2,2)
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 03-26-2014, 12:41 PM #3
    11ktran44
    11ktran44 is offline
    Registered User
    Join Date
    08-14-2010
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: conditional format based on dates.

    Quote Originally Posted by etaf View Post
    try using
    =C2>WORKDAY(B2,2)
    Thank so much for your help, Wayne! KAT
    Reply With QuoteRegister To Reply
  4. 03-26-2014, 12:55 PM #4
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,737

    Re: conditional format based on dates.

    your welcome , thanks for the rep
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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. Excel 2007 : Conditional Format based on another worksheet conditional format
    By zipper_018 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1