Results 1 to 3 of 3

Conditional Formatting Based on Date, Formulas, and Text

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    Here
    MS-Off Ver
    MS Office 2007
    Posts
    35

    Conditional Formatting Based on Date, Formulas, and Text

    Hello,

    I am looking to have conditional formatting color cells containing a formula/text white/blank.

    I currently have a sheet that colors approaching dates either red, green, or yellow based on their distance from TODAY(). This is working well but I would like any cell that doens't contain a date to remain filled white. I'm not exactly sure the best way to accomplish this so I am asking this very helpful forum.
    Conditional Formatting Help.xlsx
    I have attached the sheet that I am working with, feel free to ask any questions.

    Simplified: I would like to exclude cells that do not have a date from this formatting.
    Last edited by Building; 02-04-2016 at 02:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting with date formulas?
    By Meagan29 in forum Excel General
    Replies: 2
    Last Post: 08-18-2015, 12:56 AM
  2. [SOLVED] Conditional Formatting Formulas for Date, Text and Values/Numbers
    By pblobe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2013, 12:26 AM
  3. [SOLVED] Conditional formatting based on text in one cell, date in another
    By Chuck_N in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2013, 11:34 AM
  4. [SOLVED] Conditional Formatting based on a Date Cell and a text Cell.
    By Clark85 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-09-2013, 07:53 AM
  5. Conditional Formatting based on formulas
    By Lloyd04 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2013, 01:03 PM
  6. Conditional Formatting based on formulas
    By hunkietechie in forum Excel General
    Replies: 4
    Last Post: 02-15-2011, 11:20 AM
  7. Conditional formatting based on text in cell and a corresponding date
    By livinglegend629 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2010, 05:10 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