+ Reply to Thread
Results 1 to 4 of 4

Calendar and Conditional Formatting

  1. #1
    Registered User
    Join Date
    03-07-2014
    Location
    Petersburg, Virginia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Calendar and Conditional Formatting

    Good morning. I have been trying to create a PTO calendar to keep track of my vacation hours I use at work. I have it set up how I want except I cannot get the conditional formatting to work how I want. My goal is to have it where in column "AC" I will type in a date like 3/7/2014 and it will highlight in the calendar cells A6:W40. I can make that work if I was doing just 1 day but I have a list of days and I didnt want to have to create a new rule for each cell to do an Specific Text. Can I use the Specific Text or something like it so it will search all of them? Attached is the calendar I am working on.
    Attached Files Attached Files

  2. #2
    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,732

    Re: Calendar and Conditional Formatting

    i have highlighted
    =$A$7:$W$40

    and used

    =AND(COUNTIF($AC$7:$AC$40,A7),A7<>"")

    this looks down the column AC from row 7 to 40

    if you want to extend just change the range or apply to column

    see attached
    Attached Files Attached Files
    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.

  3. #3
    Registered User
    Join Date
    03-07-2014
    Location
    Petersburg, Virginia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Calendar and Conditional Formatting

    Thank you very much!

  4. #4
    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,732

    Re: Calendar and Conditional Formatting

    your welcome, thanks for the rep

+ 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. Conditional Formatting - Calendar
    By braydon16 in forum Excel General
    Replies: 2
    Last Post: 12-07-2011, 04:32 PM
  2. conditional formatting in calendar
    By albert28 in forum Excel General
    Replies: 2
    Last Post: 07-05-2010, 03:36 AM
  3. Conditional Formatting for Calendar
    By Peke in forum Excel General
    Replies: 2
    Last Post: 02-14-2010, 01:17 PM
  4. Help with conditional formatting:get this calendar
    By ellisbobby in forum Excel General
    Replies: 8
    Last Post: 08-06-2009, 01:50 AM
  5. [SOLVED] Calendar - conditional formatting?
    By Valery2105 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-27-2006, 01:45 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