+ Reply to Thread
Results 1 to 5 of 5

Getting Blank Cells to Conditionally Format

  1. #1
    Forum Contributor
    Join Date
    06-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    136

    Getting Blank Cells to Conditionally Format

    I have conditional formatting setup to show any value greater or equal to 0 to turn green. Then another rule any value less that 0 to show red.
    I have an if formula in these cells which has the cell show "" if nothing is in the column before it and while there is no value displaying on the sheet the cells that are blank are still turning green.

    Any suggestions?

    Thanks!

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Getting Blank Cells to Conditionally Format

    Use something like this as the CF formula:
    Please Login or Register  to view this content.
    and don't assign any conditional formats to that situation.
    Move that test to the top and and check "Stop if True"
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Contributor
    Join Date
    06-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Getting Blank Cells to Conditionally Format

    That doesn't seem to work. Maybe I'm not giving enough info?
    I put =($E$7:$E$22="") in as those are the cells that I want all the formatting in. It still comes up green. Maybe its a problem with the original two rules? I used Cell value is < 0 and cell value is >= 0

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Getting Blank Cells to Conditionally Format

    These $E$7:$E$22 are probably the cells that will contain the conditional formatting.

    If that's true, then this would be the approach:
    • Select E7:E22, with E7 as the active cell
    • Home.Conditional_Formatting.Manage_Rules
    ...Select (or create) the new rule
    ...the CF formula would be: =(E7="")
    (And that formula would be applied to each individual cell in the referenced range.)

    Does that help?

  5. #5
    Forum Contributor
    Join Date
    06-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Getting Blank Cells to Conditionally Format

    Yes that did it. Ok I was getting confused on the range part. For some reason excel kept wanting to put $ in front of E and 7 which was causing it not to work. Once I deleted that it worked out.

    Thanks a ton!

+ 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. Using COUNTIF to Conditionally Format Cells
    By brreaves in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2014, 12:33 AM
  2. [SOLVED] How to compare cells and format conditionally over a whole sheet
    By HilaryP in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-30-2014, 10:33 AM
  3. Macro to Conditionally Format Cells based on another cells value
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-07-2013, 03:05 AM
  4. Replies: 1
    Last Post: 03-15-2013, 06:46 AM
  5. [SOLVED] conditionally format the first value to the right of a blank cell
    By skoehler9 in forum Excel General
    Replies: 10
    Last Post: 09-14-2012, 04:21 PM
  6. Replies: 2
    Last Post: 04-06-2006, 11:10 AM
  7. [SOLVED] conditionally format cells
    By elad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2005, 01:06 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