Results 1 to 8 of 8

Conditional formatting cells to show no format if the cell contains a date

Threaded View

  1. 05-03-2014, 05:54 AM #1
    xWiZardx
    xWiZardx is offline
    Registered User
    Join Date
    04-11-2010
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    44

    Conditional formatting cells to show no format if the cell contains a date

    Hi all, how can I condition format a cell to show no format if the cell contains a date

    Please see the attached book1.xlsx for more info

    Thanks for your help

    Book1.xlsx
    Last edited by xWiZardx; 05-03-2014 at 12:17 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting - If cell value is a date, copy to another cell and show text
    By snanks in forum Excel General
    Replies: 1
    Last Post: 01-30-2014, 10:04 AM
  2. Conditional formatting based on date - delete format if a date is entered in next cell
    By menstonbantam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  3. Conditional Formatting - Format one cell based off of text from other cells
    By dfelock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2013, 03:28 PM
  4. Excel 2003 VBA or conditional formatting. Date in one cell needs to format remote cell
    By Duffgen in forum Excel General
    Replies: 5
    Last Post: 06-30-2013, 06:54 PM
  5. Conditional Date Formatting with a Custom Cell Format
    By kqueen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2012, 01:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1