Results 1 to 6 of 6

Conditional formating dates

Threaded View

TimlmiT Conditional formating dates 04-16-2015, 09:42 AM
AlKey Re: Conditional formating... 04-16-2015, 09:50 AM
TimlmiT Re: Conditional formating... 04-16-2015, 10:00 AM
AlKey Re: Conditional formating... 04-16-2015, 10:15 AM
TimlmiT Re: Conditional formating... 04-16-2015, 11:19 AM
TimlmiT Re: Conditional formating... 04-16-2015, 11:28 AM
  1. #1
    Forum Contributor
    Join Date
    06-21-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    186

    Conditional formating dates

    gurus,


    I am trying to conditionally format a cell that when a date is entered, the cell is filled green. However, if the cell does not contain a date it should be no fill. Meaning, if the user enters a hyphen or NA in the cell, I don't want the cell to format to green.

    Unfortunately in my sample spreadsheet, when a hyphen or even NA is entered in the cell, the cell fill is set to green. I cannot figure out the formula that only sets the fill to green when a date is entered.

    I understand that excel translates dates to numbers, but I don't understand why a hyphen or even NA is also triggering the fill setting.

    I have tried a couple of formulas in my sample to no avail. Please help and show my what I am doing wrong.

    TIA,
    Tim
    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 Formating of Dates
    By Karen615 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2014, 01:42 PM
  2. Conditional Formating Dates
    By LKH2859 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2013, 10:32 AM
  3. I need help with a conditional formating using dates
    By Gumbercules563 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-21-2013, 09:59 AM
  4. Excel 2007 : Conditional Formating using dates
    By kuntz92 in forum Excel General
    Replies: 2
    Last Post: 11-02-2011, 08:31 AM
  5. Install dates formating using conditional formating?
    By Jerry Eggleston in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 01:49 PM

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