Results 1 to 4 of 4

Excel help on flagging date and not flagging blank cells

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2002
    Posts
    2

    Excel help on flagging date and not flagging blank cells

    I have a spreadsheet that I have created and I need the dates entered to flag red if they are less than or equal to 30 days from today's date. I entered the conditional cell value of =TODAY()+30 and it flags red like I need it to. The problem now is that all cells in that column that are blank flag red. I would like them to stay the original color when blank. I have attached the file. The column is called "Release Date". Any help would be much appreciated, thanks in advance.
    Attached Files Attached Files
    Last edited by abberoth; 07-19-2011 at 06:48 PM. Reason: Mark solved

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