Results 1 to 6 of 6

Traffic light Formula not working

Threaded View

TonydeBurgh Traffic light Formula not... 06-15-2013, 01:56 PM
popipipo Re: Help Please! 06-15-2013, 01:57 PM
popipipo Re: Traffic light Formula not... 06-15-2013, 02:06 PM
TonydeBurgh Re: Traffic light Formula not... 06-15-2013, 02:08 PM
popipipo Re: Traffic light Formula not... 06-15-2013, 02:17 PM
aydeegee Re: Traffic light Formula not... 06-16-2013, 03:57 AM
  1. #1
    Registered User
    Join Date
    06-15-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Traffic light Formula not working

    Im trying to generate a formula in Excel 2007 that will allow me to implement a 'traffic light' system for dates on a training document at work. I need to have the cells that contain dates in the following parameters: -
    less than 9 months old stay green,
    9-12 months go yellow,
    12+ go red.
    I am aware of the now function, but is there an easier way as currently I have to add 3 layers per column in conditional formatting.

    I hope there is!

    Thanks in advance..............
    Last edited by TonydeBurgh; 06-15-2013 at 01:59 PM.

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