Results 1 to 9 of 9

Conditional Formatting: formula results "" counting as greater than x

Threaded View

  1. #1
    Registered User
    Join Date
    07-31-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    6

    Conditional Formatting: formula results "" counting as greater than x

    Hi,
    I want to conditional format to highlight values greater than x (in this case 1:59). My formula intentionally blanks out certain rows which should be disregarded (""). These "" cells are being highlighted. It seems the "" cells are counted as infinitely high numbers ("less than" anything does not highlight them). How can I highlight only the non-blank cells that are greater than a given value?
    Thank you!
    (p.s. please disregard those columns to the left, I have a garbage data source and have to use cleaner columns)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] conditional formatting - highlighting all cells greater than "x"
    By random22223 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2019, 03:54 PM
  2. Replies: 7
    Last Post: 10-21-2019, 03:34 PM
  3. Replies: 7
    Last Post: 11-08-2017, 01:31 PM
  4. [SOLVED] IF Formula not working - need to return "NO" if cell is 1% greater or "YES" if less 1%
    By maryren in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2013, 11:34 AM
  5. [SOLVED] Cell Formula to count time with "Greater Than or Equal to" and "Less Than"
    By chriswhite1982 in forum Excel General
    Replies: 3
    Last Post: 06-16-2013, 12:30 AM
  6. [SOLVED] VBA coping conditional formatting " results" to new worksheet.
    By TERRI LEE in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2013, 05:48 AM
  7. [SOLVED] Conditional formatting - formula if cell does NOT contain "," or "@"
    By Armitage2k in forum Excel General
    Replies: 12
    Last Post: 12-02-2012, 06:23 AM

Tags for this Thread

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