+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting with Macro

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    Monterrey, Mexico
    MS-Off Ver
    Excel 2003
    Posts
    2

    Conditional Formatting with Macro

    I have an Excell Sheet with a calendar (months in ascending order) in the first row (N1:AK1) with the format jan-11, feb-11, mar-11, etcetera
    and i have a date with the same format on a column eg. (M2:M147) I want that the cells in between the columns for the calendar and rows for the dates check the calendar and if the month in the row in which they are is after or the same as the date on their column but is sooner than 12 months after the date on the column it highlights in yellow, and i want this to be open so that if I add months to the calendar or cases (dates) they could have the same formatting.

    Thank you very much.

    If not clear or more information needed, please tell me. :D

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Conditional Formatting with Macro

    Not clear. Please post a sample workbook and explain what youo expect to get and why.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-12-2012
    Location
    Monterrey, Mexico
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Conditional Formatting with Macro

    SOLVED :D thanks anyways

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Conditional Formatting with Macro

    You want to share?

    Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.


    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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