+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting - dates and empty cells

  1. #1
    Registered User
    Join Date
    02-23-2011
    Location
    Hampshire, England
    MS-Off Ver
    Excel 2007
    Posts
    71

    Conditional formatting - dates and empty cells

    I have a condition to check an individual is no older than 18 using "less than" but the empty cells are also being changed. How can I stop this from happening?

    Thanks

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Conditional formatting - dates and empty cells

    Try this as the formula in your conditional formatting - B2 is first cell in range being formatted
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Registered User
    Join Date
    02-23-2011
    Location
    Hampshire, England
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Conditional formatting - dates and empty cells

    That's great thanks, but I have changed it so it highlights DOBs for people older than 18.

    Now I will change my DOBs for parents .

+ 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 empty cells
    By haiching in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-11-2015, 11:27 PM
  2. Replies: 1
    Last Post: 07-11-2014, 12:37 PM
  3. [SOLVED] Conditional formatting if two cells are not empty?
    By shreksbro in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2013, 02:43 AM
  4. Conditional Formatting if other cells are empty
    By angeleire in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-15-2013, 08:36 PM
  5. Replies: 4
    Last Post: 08-29-2013, 11:23 AM
  6. Replies: 5
    Last Post: 03-14-2012, 04:46 PM
  7. Conditional Formatting Color Empty Cells in a Colum
    By rmm30 in forum Excel General
    Replies: 2
    Last Post: 09-28-2006, 09:35 AM

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