+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting - ignore Blank Cells

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    1

    Conditional Formatting - ignore Blank Cells

    I'm using the following formula in Conditional Formatting which will hightlight a cell red if the date is older than todays date and has a status which is not OVERDUE or CLOSED.

    =AND(L7<>"Overdue",L7<>"Closed",G7<TODAY())

    But if L7 and G7 are blank the formatting highlights the cells red. I'd like for this not to happen for rows yet to be completed.

    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Conditional Formatting - ignore Blank Cells

    Just add blank check, ie

    =AND(L7<>"", G7<>"",L7<>"Overdue",L7<>"Closed",G7<TODAY())
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Replies: 6
    Last Post: 09-20-2020, 06:58 PM
  2. Conditional formatting needs to ignore blank spaces
    By Siciro in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-08-2014, 11:50 AM
  3. Replies: 5
    Last Post: 05-18-2013, 07:49 PM
  4. [SOLVED] How to get Conditional Formatting to ignore blank cells?
    By AndyHawke in forum Excel General
    Replies: 3
    Last Post: 08-22-2012, 08:25 AM
  5. How to ignore blank cells in conditional formatting?
    By Gooford in forum Excel General
    Replies: 5
    Last Post: 08-22-2012, 08:06 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