+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Based on Date, Formulas, and Text

  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.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,108

    Re: Conditional Formatting Based on Date, Formulas, and Text

    use an AND and the rest of the formula

    =AND( cell <> ""

    lets have a look at the sheet and come back here - watch for an edit


    Actually add a new rule
    A5=""
    and no format
    then make sure thats at the top of the list and stop if true

    see attached
    Attached Files Attached Files
    Last edited by etaf; 02-04-2016 at 02:55 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Conditional Formatting Based on Date, Formulas, and Text

    In CF rules, use

    Format cells only that contains -- Blanks -- No colour

    Keep this as the first rule and check the 'Stop if true' box (this is crucial!)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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. 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