Make "False" cell blank

S

Suzanne Mead

I do not want the word "false" to show in a cell. How do I make that
cell blank without disturbing the formula?
 
F

Frank Kabel

Hi
you may post your formula. Assuming you use an IF formula try something
like
=IF(A1=1,"one value","")
 
A

Art

Suzanne,

Try using conditional formatting.
Select the cell in question.
Go to format, conditional formatting.
Under the "condition" pick "forumla is".
Now, assume that the cell you're concerned about is C9.
Type =(C9=FALSE) into that box.
Then, click on format and pick the "color" box and select white.
This should do it.

One thing to watch out for. If it doesn't work, go back in and look at the formula you typed. If Excell put quotes around any part of it, remove the quotes, hit OK and try again.

Art
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
Blank pages 0
Nested if statements creating a blank cell 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
HELP!!!!!!!!! 2
VBA Export to PDF 0
Copy addition formula of non-consecutive horizontal cells 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Top