Results 1 to 6 of 6

Conditional formatting. Highlight cells that meet a criteria but ignore blank cells.

Threaded View

  1. #1
    Registered User
    Join Date
    09-02-2010
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2003
    Posts
    18

    Conditional formatting. Highlight cells that meet a criteria but ignore blank cells.

    -I have two columns of numbers.
    -There are blank cells in each column that appear sporadically.
    -In each row of numbers, I want to create a conditional format that highlights a cell if the number in the cell is greater than a designated value.
    -Currently I am using: Conditional formatting 'formula' =ABS(C4-C3)>.1 OR =ABS(D4-D3)<.1 for the respective column of numbers.
    -This formula does not work now that I have empty cells between the values. All the blank cells are highlighted and the subtraction can not take place if the cell is blank.
    -I want the formula to not see the blank cells and make the comparison between the first vale and the next vale in the series.
    -I do not want to sort the blank rows out and then replace.
    Thank you,
    Daniel

    Please see attachment: TESTAE042701.csv
    Attached Files Attached Files

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