1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Conditional formatting hidden zeros

Discussion in 'Business Applications' started by Pedro15, May 4, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. Pedro15

    Pedro15 Thread Starter

    Joined:
    Oct 5, 2008
    Messages:
    385
    Am trying to CF a range where condition I want is "If cell is greater than 1", so that if empty no conditional formatting.

    Have ascertained by using ISBLANK that the value in cells is "0".

    Edit / Replace cannot locate any "0's" nor can it find a "$" I used to see is the replace function was working.

    When I highlight the range and CF as "If cell is greater than 1" all cells in range respond where I only want the one with a real value in it.
    Adjoining columns CF quite OK.

    Suggestions welcome.

    Pedro
     
  2. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    63,177
    cells greater than 1
    will not show up for 0 and 1
     
  3. Pedro15

    Pedro15 Thread Starter

    Joined:
    Oct 5, 2008
    Messages:
    385
    Conditional format condition
    =(ISNUMBER(cell details) entered in first cell of range.

    Pedro
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Solved Conditional formatting
  1. nomad
    Replies:
    1
    Views:
    118
  2. Jes in DC
    Replies:
    8
    Views:
    466
  3. Adrian888
    Replies:
    3
    Views:
    252
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1051913