+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting - Date formats

  1. #1
    Registered User
    Join Date
    01-14-2015
    Location
    Arizona
    MS-Off Ver
    2010
    Posts
    3

    Conditional Formatting - Date formats

    Is it possible to apply conditional formatting to a column based on a dates format. Example --> highlight the cell yellow if the contents of the cell are not in the following format: MM/DD/YYYY

    Thanks,

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Conditional Formatting - Date formats

    Formatting doesn't affect the value within a cell, which is what CF is based on, so I don't think you can do that.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Applying Formats from Conditional Formatting to Other Cells
    By McStagger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2014, 04:02 PM
  2. Remove conditional formatting, keep formats.
    By elmaco12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 10:58 AM
  3. [SOLVED] Conditional Formatting Formats All
    By uckycool in forum Excel General
    Replies: 8
    Last Post: 10-03-2012, 11:06 AM
  4. Replies: 1
    Last Post: 09-22-2011, 05:42 AM
  5. VBA based conditional formatting (>3 formats needed)
    By ob3ron in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2007, 09:08 PM

Tags for this Thread

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