1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Conditional Formatting Dates (Excel)

Discussion in 'Business Applications' started by mikejreading, Aug 19, 2009.

Thread Status:
Not open for further replies.
  1. mikejreading

    mikejreading Thread Starter

    Joined:
    Jul 2, 2009
    Messages:
    63
    Hey Guys,

    I am currently working with Excel 2007, but need this spreadsheet to work on older versions of Excel also.

    I have a training tracker spreadsheet, containing details of what training has been completed by an employee and when.. some of this training is one off (machinery etc), but some of it is required to be repeated on a timescaled basis (6 months, annually, etc.).

    The fields currently contain the date the employee had their training signed off.. how can I make conditional formatting work so that say, after 6 months, the field colour turns red to make it stand out...??

    Thanks in advance... let me know if a copy of the speadsheet will help, I can remove all personal details and give you a copy to play with.

    Cheers :)
     
  2. Jubbaloo

    Jubbaloo

    Joined:
    May 11, 2009
    Messages:
    156
    Hiya
    If you set the selection with the details as in the attached picture it should work.Please let me know if it doesnt and if it does then please mark this thread as solved.[​IMG]
     
  3. mikejreading

    mikejreading Thread Starter

    Joined:
    Jul 2, 2009
    Messages:
    63
    Solved. Thanks a lot.. i was using =NOW() instead of =TODAY()

    Schoolboy errror :)
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Solved Conditional Formatting
  1. Squashman
    Replies:
    5
    Views:
    194
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/853833

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice