+ Reply to Thread
Results 1 to 4 of 4

Use Conditional Formatting for calendar that highlights workweeks of project dates.

  1. #1
    Registered User
    Join Date
    08-03-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    2007
    Posts
    3

    Use Conditional Formatting for calendar that highlights workweeks of project dates.

    Hi,
    I think this should work but it doesn't. Any ideas?
    =AND($B4>=D$2,$C4<=D$3)

    Should look like this
    Excel Conditional Formatting.png

    Thanks,

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Use Conditional Formatting for calendar that highlights workweeks of project dates.

    Hi and welcome to the forum

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff)

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

    (and just fyi, in that pic, B, C and D are hidden anyway???)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-03-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    2007
    Posts
    3

    Re: Use Conditional Formatting for calendar that highlights workweeks of project dates.

    Thanks for responding to my post. Attached is the worksheet.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-03-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    2007
    Posts
    3

    Re: Use Conditional Formatting for calendar that highlights workweeks of project dates.

    I figured I out, solved. The trick was to separate the logic out of the conditional formatting and then to use a logic function to set up the right condition in each cell. The logic function ORs 3 conditions, 1) testing for dates that Start within a workweek, 2) dates that Span the workweek, and 3) dates that End within a workweek. Attached worksheet, the first section shows the logic function without the conditional formatting, the second section shows the conditional formatting applied. Hope this helps somebody else.

    Bob
    Attached Files Attached Files

+ 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: Cell highlights after a given date
    By peoplemover in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 06:49 PM
  2. [SOLVED] Conditional Formatting that highlights cells on two conditions
    By jonathan.haynes in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2013, 04:54 AM
  3. Conditional Formatting Value highlights multiple values
    By brent_bris in forum Excel General
    Replies: 15
    Last Post: 04-22-2013, 11:26 AM
  4. Conditional Formatting - Calendar Dates - Excel 2007
    By DMACR00 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2012, 12:26 PM
  5. Conditional Formatting Help-highlights a single row
    By Tommy1005 in forum Excel General
    Replies: 1
    Last Post: 02-22-2011, 02:22 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