Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Conditional formatting hidden zeros


(!)

Pedro15's Avatar
Pedro15 Pedro15 is offline
Member with 332 posts.
THREAD STARTER
 
Join Date: Oct 2008
Experience: Intermediate
04-May-2012, 12:25 AM #1
Solved: Conditional formatting hidden zeros
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

Last edited by Pedro15; 04-May-2012 at 12:30 AM..
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 53,063 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
04-May-2012, 08:07 AM #2
cells greater than 1
will not show up for 0 and 1
Pedro15's Avatar
Pedro15 Pedro15 is offline
Member with 332 posts.
THREAD STARTER
 
Join Date: Oct 2008
Experience: Intermediate
04-May-2012, 04:57 PM #3
Conditional format condition
=(ISNUMBER(cell details) entered in first cell of range.

Pedro
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2