+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting as a countdown timer

Hybrid View

  1. #1
    Registered User
    Join Date
    04-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Conditional Formatting as a countdown timer

    I found a thread with conditional formulas that should be exactly what I need (with the same title) but something isn't working. I have played with the date format and the formula and am stuck. Formula doesn't seem to be recognizing date. It is highlighting all cells Yellow.

    Condition 1: Highlight cell (column B) yellow if date is within 4 months from today
    Formatting Rule: Format only cells that contain / Cell Value / Less than or equal to / ="today()+120

    Stop If True

    Condition 2: Highlight cell (column B) red if date is past today.
    Formatting Rule: Format only cells that contain / Cell Value / Less than / ="today()"

    Hopefully the file is attached.
    ConditionalFormatting.xls

    Thank you,
    CindyCapture.JPGAttachment 382937

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    606

    Re: Conditional Formatting as a countdown timer

    Hi Sassy13, you need to remove the quotes (") from the conditional formats, but in order for the red to work I had to change the yellow rule to:-
    Format only cells that contain / Cell Value / Between / =today() / =today()+120

  3. #3
    Registered User
    Join Date
    04-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Conditional Formatting as a countdown timer

    Thank you soooo much. Excel was throwing the (") on there so I thought excel was right. I had to go remove them after creating the formula. Thank you for the yellow correction as well!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Countdown Timer & Conditional Formating?
    By tomfohr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2012, 02:58 PM
  2. Countdown Timer
    By gkokaisel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2011, 08:02 PM
  3. Countdown Timer
    By colt seavers in forum Excel General
    Replies: 3
    Last Post: 01-12-2010, 12:23 PM
  4. Conditional Formatting as a countdown timer?
    By Chemistification in forum Excel General
    Replies: 3
    Last Post: 10-21-2009, 10:31 AM
  5. Countdown timer
    By Nemeo in forum Excel General
    Replies: 1
    Last Post: 05-24-2007, 09:37 PM

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