+ Reply to Thread
Results 1 to 7 of 7

Past date in column to change color

  1. #1
    Ron de Bruin
    Guest

    Re: Past date in column to change color

    Hi Cris

    You can use CF
    http://www.contextures.com/xlCondFormat01.html

    Post back if you need more help


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "Chris" <Chris@discussions.microsoft.com> wrote in message news:AD23880D-5EB9-4A6B-AA64-0951F5AD4D96@microsoft.com...
    > I'd like to have my excel sheet columns with the dates to change to a
    > specific color as the date pass's. I've racked my brain thinking of how.
    > Anyone??




  2. #2
    Kevin M
    Guest

    RE: Past date in column to change color

    Format > Conditional Formatting

    Then assign colors based on criteria you define, say, greater than Date+30,
    then format color as green (or whatever you wish). Be aware you can only use
    three conditional formats per cell.

    HTH,

    Kevin McClement
    MOS Excel Specialist

    "Chris" wrote:

    > I'd like to have my excel sheet columns with the dates to change to a
    > specific color as the date pass's. I've racked my brain thinking of how.
    > Anyone??


  3. #3
    Ron de Bruin
    Guest

    Re: Past date in column to change color

    Hi Cris

    You can use CF
    http://www.contextures.com/xlCondFormat01.html

    Post back if you need more help


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "Chris" <Chris@discussions.microsoft.com> wrote in message news:AD23880D-5EB9-4A6B-AA64-0951F5AD4D96@microsoft.com...
    > I'd like to have my excel sheet columns with the dates to change to a
    > specific color as the date pass's. I've racked my brain thinking of how.
    > Anyone??




  4. #4
    Kevin M
    Guest

    RE: Past date in column to change color

    Format > Conditional Formatting

    Then assign colors based on criteria you define, say, greater than Date+30,
    then format color as green (or whatever you wish). Be aware you can only use
    three conditional formats per cell.

    HTH,

    Kevin McClement
    MOS Excel Specialist

    "Chris" wrote:

    > I'd like to have my excel sheet columns with the dates to change to a
    > specific color as the date pass's. I've racked my brain thinking of how.
    > Anyone??


  5. #5
    Chris
    Guest

    Past date in column to change color

    I'd like to have my excel sheet columns with the dates to change to a
    specific color as the date pass's. I've racked my brain thinking of how.
    Anyone??

  6. #6
    Ron de Bruin
    Guest

    Re: Past date in column to change color

    Hi Cris

    You can use CF
    http://www.contextures.com/xlCondFormat01.html

    Post back if you need more help


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "Chris" <Chris@discussions.microsoft.com> wrote in message news:AD23880D-5EB9-4A6B-AA64-0951F5AD4D96@microsoft.com...
    > I'd like to have my excel sheet columns with the dates to change to a
    > specific color as the date pass's. I've racked my brain thinking of how.
    > Anyone??




  7. #7
    Kevin M
    Guest

    RE: Past date in column to change color

    Format > Conditional Formatting

    Then assign colors based on criteria you define, say, greater than Date+30,
    then format color as green (or whatever you wish). Be aware you can only use
    three conditional formats per cell.

    HTH,

    Kevin McClement
    MOS Excel Specialist

    "Chris" wrote:

    > I'd like to have my excel sheet columns with the dates to change to a
    > specific color as the date pass's. I've racked my brain thinking of how.
    > Anyone??


+ 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