+ Reply to Thread
Results 1 to 3 of 3

Dates older than 29 days

  1. #1
    ab
    Guest

    Dates older than 29 days

    I would like a column in my Excel spreadsheet to be made bold once the dates
    in that column are more than 29 days old.

  2. #2
    Bob Phillips
    Guest

    Re: Dates older than 29 days

    Use conditional formatting in say A1:A100 with a formula of =A1<TODAY()-29

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "ab" <[email protected]> wrote in message
    news:[email protected]...
    > I would like a column in my Excel spreadsheet to be made bold once the

    dates
    > in that column are more than 29 days old.




  3. #3
    Dave Peterson
    Guest

    Re: Dates older than 29 days

    One way is to use Format|Conditional formatting.

    Cell Value is Less Than =today()-29

    (use the dropdowns for the first two and type the last.)

    And give it a nice old format.

    ab wrote:
    >
    > I would like a column in my Excel spreadsheet to be made bold once the dates
    > in that column are more than 29 days old.


    --

    Dave Peterson

+ 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