+ Reply to Thread
Results 1 to 1 of 1

Conditional formatting Highlight Cells (Dates) that should show as blocked

  1. #1
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    116

    Conditional formatting Highlight Cells (Dates) that should show as blocked

    Hi,
    This is subsequent to a previous post and am posting a new thread for this question. I have a workbook that autofills rows based on start and end dates and joins events associated to that date. The formula permits only workdays, and no weekends and holidays. However, there are some blocked dates, and I am looking for all the cells that have any format of the blocked date to be highlighted (ddd, mmm dd, 'yy) or dddd, mmmm dd, yyyy, etc) to be highlighted. I tried conditional formatting, but it only highlights one column and in the full format. I've attached a sample workbook.
    Any suggestions?
    Thanks.
    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. Using Conditional Formatting to highlight cells based on approaching dates
    By BrutalExcel in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 06-12-2013, 11:56 AM
  2. [SOLVED] Excel 2010 Conditional Formatting to Highlight input cells based on Dates
    By chrisb84 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2013, 09:39 AM
  3. Replies: 2
    Last Post: 12-18-2012, 11:18 AM
  4. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  5. [SOLVED] How do I highlight a cell using conditional formatting and dates
    By shane561 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-27-2005, 12:10 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