+ Reply to Thread
Results 1 to 2 of 2

Thread: Conditional Formatting of Blank Cells

  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Orange, Ca
    MS-Off Ver
    Excel 2007
    Posts
    1

    Conditional Formatting of Blank Cells

    I need to CF the different cells to change fill color based on how many days from today until the date in the cell.

    Green for 31 days of greater.

    Yellow for 10 to 30 days.

    Red for 10 days or less.

    Grey for blank cells.

    Pretty sure I have the GYR figured out, but the Grey is being difficult!

    Please help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens Greece
    MS-Off Ver
    Excel 2003
    Posts
    2,297

    Re: Conditional Formatting of Blank Cells

    Hi

    As you know for the easy ones, i give you the difficults..

    Hope to helps you.
    Attached Files Attached Files
    Regards

    Fotis.

    I am proud that i am Greek.

    Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?

    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.


    My Avadar picture, is from Athens Acropolis.
    http://www.theacropolismuseum.gr

    http://www.visitgreece.gr/

+ Reply to Thread

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.2.0