Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I got a sheet like the below figure. I want to hide all the number and just keep the background color. How can I do it?

alt text

share|improve this question
1  
Please post a screen capture or something - we need to be able to check out your issue without having to download random spreadsheets. (Especially since said random spreadsheets will go away after a while, so your question will become nonsensical.) –  Martha Oct 5 '10 at 13:59
    
Thanks, I've updated my question. –  Nam G VU Oct 6 '10 at 3:44

3 Answers 3

up vote 4 down vote accepted

You can use a custom number format on the cell range:

"";"";"";""

This format string is basically saying display an empty string if the cell contains a positive number, a negative number, 0 or text. Error values will still be shown.

share|improve this answer
    
Cool! Thanks Mike! This works perfectly for me. –  Nam G VU Oct 6 '10 at 3:41

The only problem with the custom number format trick (i.e. entering ;;; or "";"";"";"" in the format box) is that it makes it impossible to copy & paste the numbers to a different program.

How are you getting the different cell backgrounds? Because presumably, if the method can affect the background color, then it can also just as easily change the font color. The same set of colors is available in each case, so you can simply set the conditional formatting (or whatever it is) to make the font color match the background.

share|improve this answer
    
+1 for ;;; which is shorter than "";"";"";"" but -1 because this should really be a comment, not an answer. But +1 again for mentioning this breaks copy/paste to other apps. Workaround is to select, apply normal formatting (Ctrl + ~), copy (Ctrl + C), paste into the other app and then and undo (Ctrl + Z) when you're done. –  Mike Fitzpatrick Nov 18 '10 at 7:42
    
@Mike Fitzpatrick: my actual suggestion is to format the cells to use the same color for both the background and the contents, using whatever conditional formatting was used to get the cell backgrounds different in the first place. This is a completely different answer than any of the others, so I fail to see how this should be a comment. –  Martha Nov 18 '10 at 14:47

You can create a conditional formula and change both the font color and the background color to be the same thing.

The conditional formula will go something like this:

IF(A1>=100, TRUE, FALSE)  

The TRUE keyword (exact words) run the conditional format. The FALSE keyword will tell excel to look at the next conditional statement.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.