Results 1 to 8 of 8

conditional formatting

Threaded View

  1. #1
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    conditional formatting

    Hi Guys

    Cells B10:B107 contain the formula

    =IF(O10="","",NETWORKDAYS(TODAY(),O10)&" days ")
    which acts as (in this case) a deadline countdown which tell the user how many days there are left to respond to a complaint.

    I wanted to add conditional formatting so it is very clear at a glance which ones are urgent.

    Red = <=5
    Amber = Between 6 & 9
    Green = >=10

    The issue i am encountering is the the Blank Cells within the range b10:b107 (blank as Col 0 is unpopulated) are appearing as (Format) green I would like them to be left without formating! Any ideas on how to achieve this ? cheers

    See database tab of attachment col B

    Thanks for your response.
    Attached Files Attached Files
    Last edited by Blake 7; 02-15-2012 at 10:31 AM.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

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