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:
    376
    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:
    55,965
    cells greater than 1
    will not show up for 0 and 1
     
  3. Pedro15

    Pedro15 Thread Starter

    Joined:
    Oct 5, 2008
    Messages:
    376
    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...
Thread Status:
Not open for further replies.

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