Results 1 to 3 of 3

Need help conditional formatting a column with formulas

Threaded View

  1. #1
    Registered User
    Join Date
    07-21-2013
    Location
    london england
    MS-Off Ver
    Microsoft Office 365
    Posts
    98

    Need help conditional formatting a column with formulas

    Please help?! I have 3 columns with Start Date, Target Date, and Number of working days. There is a formula in the Working days column to produce the values.
    I want to condition format the Working days column using the traffic light icons so that:
    if the working days are over the target date then red traffic light icon,
    if the working days are equal to the target date then amber traffic light icon,
    if the working days are under the target date then green traffic light icon,
    if there is no start date, then all the rows should be blank, so no traffic light icon,
    I need to see the values for the number of working days as well as the traffic light icons.
    I have attached my worksheet for you to work on. If you could let me know how you achieved this it would be much appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting f=Formulas - Please help !!!
    By harmy017 in forum Excel General
    Replies: 3
    Last Post: 06-27-2012, 05:19 AM
  2. Excel 2007 : formulas with conditional formatting
    By drj73 in forum Excel General
    Replies: 4
    Last Post: 03-07-2012, 09:09 AM
  3. Replies: 1
    Last Post: 09-14-2010, 03:45 AM
  4. Conditional formatting using formulas
    By harishkumar09 in forum Excel General
    Replies: 3
    Last Post: 09-07-2006, 05:24 PM
  5. [SOLVED] Conditional Formatting for Formulas
    By Murat Gordeslioglu in forum Excel General
    Replies: 3
    Last Post: 06-22-2006, 04:10 AM

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