+ Reply to Thread
Results 1 to 3 of 3

Date to Calendar

  1. #1
    Registered User
    Join Date
    09-13-2010
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    2

    Date to Calendar

    Hello.

    I'm having a struggle to find a way to sort out my problem. If you could clarify I would be seriously appreciated.

    I have an excel sheet where the whole column A and B are blank, and starting on column C and forwards I have a year calendar.

    So far so good.

    What I'm trying to find out is the right formula to:

    write manually a date on one of the cells in Column A or B and the calendar automatically recognises that cell and highlights the date on the calendar.

    I'm sorry if you don't understand I'm trying my best.

    Thank you for any help you can give me.

    RLory

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Date to Calendar

    Hello RLory,

    you can do that with conditional formatting. Select all the cells of your calendar, then set a conditional format with Formula is and enter the formula

    =OR(C1=$A$1,C1=$B$1)

    Then select a format for the cells.

    This assumes that your calendar starts in C1 and the dates you enter will be in A1 or B1.

    If that does not help, please post a sample workbook, so we don't have to guess your spreadsheet layout.

  3. #3
    Registered User
    Join Date
    09-13-2010
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Date to Calendar

    It's almost perfect.

    Cheers for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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