Results 1 to 4 of 4

Conditional Formatting as a countdown timer?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    147

    Conditional Formatting as a countdown timer?

    I have the following spreadsheet and i am looking to automate when people need training.

    The idea is that when they enter the date they recieved their PDR it auto posts the date it needs re doing in column C. To emphasise it and make it easier i am trying to use the formula is part of conditional formatting so that the spreadsheet goes green when date entered, orange when there is 30 days till renewal and red when its over due.

    I've been trying formulas such as =c2-today()<30 in the conditional formatting box but i cant seem to get it to work. Please could someone help?
    Attached Files Attached Files
    Last edited by Chemistification; 10-21-2009 at 10:32 AM.

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