+ Reply to Thread
Results 1 to 2 of 2

Find empty/null/blank cell in a conditional format

  1. #1
    Registered User
    Join Date
    11-03-2006
    Location
    Birmingham, UK
    Posts
    18

    Exclamation Find empty/null/blank cell in a conditional format

    Hi Guys,

    i'm hoping there is a quick solution to this problem:

    I have created a conditional format which highlights the cell in red if the value is less than 40. This work fine but the conditional format activates before a value is entered (i.e. even if a value is not entered the cell appears highlighted in red).

    I want to create conditional format that only highlight the cell red when a value is entered into the cell by the user. If the cell is blank or empty then i don't wnat the conditional format to activate (or i would like to have a conditional format to restore to the default colour).

    Is there a way i can capture blank/empty values in a cell when using the conditional format?
    I don't mind whether it talkes one or many conditional formats to do what wnat to, as long as it works correctly.

    Regards,

    Shuja

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    For your conditional formatting formula, use =AND(A1<>"",A1<40).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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