+ Reply to Thread
Results 1 to 3 of 3

Conditional format range based on date

  1. #1
    Registered User
    Join Date
    11-06-2008
    Location
    memphis, tn
    MS-Off Ver
    2010
    Posts
    16

    Conditional format range based on date

    Hi all,

    I have a monthly calender, with each month on its own sheet. I have a sheet named Holidays, which list the holidays. I have been able to use conditional format and highlight the dates in the months the holidays fall on, but I would like to highlight a range of cells below the date on monthly sheet. I have attached a sample of what I have and would like to achieve. I am not much good at using VBA, but would not be against using it either. Thanks for any help.
    Steve
    Attached Files Attached Files
    Last edited by sd7000; 09-08-2009 at 03:54 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Conditional format range based on date

    Conditonal formatting will do the trick, see attachment.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-06-2008
    Location
    memphis, tn
    MS-Off Ver
    2010
    Posts
    16

    Re: Conditional format range based on date

    Works like a champ, thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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