+ Reply to Thread
Results 1 to 3 of 3

cell highlight with notes

  1. #1
    Registered User
    Join Date
    07-01-2008
    Location
    Wales, UK
    Posts
    29

    cell highlight with notes

    Hi all

    I have a query regarding the attached file of mine.

    It's what I call my never ending calendar with birthday list.

    What I'm after is when the day and month from the 'list' sheet matches the dates shown in range on the 'calendar' sheet to highlight the matched cells in a different colour and insert a note also on the 'calendar' sheet at the appropriate cell to show the details of who's birthday is due on that date.

    The cell formulas currently on the 'calendar' sheet has to stay in tack though otherwise the cell details will appear wrong next month.

    BIRTHDAY COMPLETE BLANK2.XLS

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,782
    Hi
    When you say insert a note, do you mean add names to the 'comment' box that's attached to every cell. If it's just a question of seeing who has a birthday on a particular day, why don't you just filter the 'List' sheet, either manually or have a macro do it?

    Rgds

  3. #3
    Registered User
    Join Date
    07-01-2008
    Location
    Wales, UK
    Posts
    29
    I figured that with the limited space available for information that a comments box would probably be better but I'm open to other options.

    What you see in the file is a starting block to consolidate pieces of information into the calendar sheet, there is other information that I also want to show from other sheets but I just need a starting point on how to get the ball rolling so to speak, I can then adapt it as and when I need to

+ 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