+ Reply to Thread
Results 1 to 2 of 2

highlight an entire row if a date in one column falls between a given range

  1. #1
    cfmartin76@gmail.com
    Guest

    highlight an entire row if a date in one column falls between a given range

    Apparently Iposted this on the wrong newsgroup, so I'm reposting here.

    I would like to know if there is a macro that automaticalle highlights
    an entire row if a date located in one column falls between a given
    range:

    TITLE DAY1 DATE
    1 Math Mon 5/15/06
    2 History Tue 6/17/06
    3 English Wed 8/13/06


    If I have the above information, can I create a macro to highlight in
    bold the entire row if a cell in column "DATE' is between 6/01/06 and
    6/20/06? (row 2 in this case)


    Thanks!


  2. #2
    Ron Coderre
    Guest

    RE: highlight an entire row if a date in one column falls between a gi

    Try something like this:

    Select Row_2 through Row_4 (entire rows)

    From the Excel main menu:
    <format><conditional formatting>
    Cell formula is: =AND($C2>=(--"6/1/2006"),$C2<=(--"6/20/2006"))
    Click the [Format...] button
    Set your formatting scheme
    Click [OK]
    Click [OK]

    Adjust range references to suit your situation.

    Does that help?
    ***********
    Regards,
    Ron

    XL2002, WinXP


    "cfmartin76@gmail.com" wrote:

    > Apparently Iposted this on the wrong newsgroup, so I'm reposting here.
    >
    > I would like to know if there is a macro that automaticalle highlights
    > an entire row if a date located in one column falls between a given
    > range:
    >
    > TITLE DAY1 DATE
    > 1 Math Mon 5/15/06
    > 2 History Tue 6/17/06
    > 3 English Wed 8/13/06
    >
    >
    > If I have the above information, can I create a macro to highlight in
    > bold the entire row if a cell in column "DATE' is between 6/01/06 and
    > 6/20/06? (row 2 in this case)
    >
    >
    > Thanks!
    >
    >


+ 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