Results 1 to 6 of 6

Prevent Conditional Formatting on Blank Cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Prevent Conditional Formatting on Blank Cells

    I want to highlight identical entries between two columns, using conditional formatting on the first column, but if the entry in both columns is blank, I don't want the cell highlighted. I tried using

    =NOT(ISBLANK(A1))=NOT(ISBLANK(C1))

    but this doesn't prevent blank matches from being highlighted, is there any wayto do this? I've attached a quick sample. In the sample I wouldn't want cell A6 to be highlighted because both A6 and C6 are blank.

    Many thanks
    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