Results 1 to 4 of 4

How to conditionally format cells that look empty but are not actually empty?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-03-2013
    Location
    Costa Rica
    MS-Off Ver
    MS Excel 365
    Posts
    120

    How to conditionally format cells that look empty but are not actually empty?

    Hi there!

    First of all, thanks for reading my post.
    Second of all, please consider that this post should've been named as: How to conditionally format cells that DON'T look empty. I realized about the mistake once I have submitted my post, so I cannot correct it now.

    Here's my situation:

    I have this formula on cell A1 on Sheet2:

    =IF(Sheet1!A1="","",Sheet1!A1)

    Then I drag the formula to the cells below on column A on Sheet2.
    How can I set up a formula on the conditional formatting feature so as to highlight (say, for instance, color in yellow) ONLY those cells that DON'T look empty. If you take a look at my formula, chances are it will return nothing on some cells, depending on content from Sheet1. Yet, those cells wouldn't be empty; they still have content (a formula, on this case), so I can't use the condition =A1<>"" on the conditional formatting feature, because cells that appear as "empty" are not actually empty; so, eventually, all will be highlighted.
    Last edited by alchavar; 10-25-2013 at 12:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MACRO to empty a range of cells based on whether specified cell is empty
    By TBJV in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2013, 10:35 PM
  2. Clear empty cells not working since they are not empty
    By Skogsborg in forum Excel General
    Replies: 2
    Last Post: 04-25-2013, 04:25 AM
  3. Replies: 5
    Last Post: 01-12-2013, 12:16 AM
  4. [SOLVED] still have empty cell after run Delete empty cells code
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2012, 04:28 PM
  5. [SOLVED] While writing files from another workbook, keep empty cells empty!
    By nivoe in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 12:25 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