Results 1 to 3 of 3

Calendar, highlight Sundays and federal holidays using CF

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2007
    Posts
    26

    Thumbs up Calendar, highlight Sundays and federal holidays using CF

    Hi,

    Trying to workout conditional formatting to highlight Sundays and federal holidays in Excel calendar.

    I got the Sundays working having separate formula for every day ( I'm sure there must be better, simpler, "one for all" formula, but I failed to find one.
    Anyway, it works the way it is, unless someone is willing to correct it.

    My problem is to do same as above, but for federal holidays.
    There is a list of holidays in Sheet2 named Federal.

    PS. Excel 2007 file, macro enabled to populate any dates

    Thanks
    Attached Files Attached Files

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