Hide Cell based on value of other cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way that you can hide the value of a cell depending on the value
of the cell directly in front of it?
 
If we want to hide D5 if C5 has the value 1, use conditional formatting on D5
to Formula Is:
=C5=1
and pick the font color to match the background color.
 
How do I do it if I want the condition of C5 to be "Blank" instead of a
number value?
 
What is currently in C5?

If a formula you could enter in C5 something akin to

=IF(ISNUMBER(B5),"",B5)


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Hide columns based on row values 2
Hide cell based on value of another cell 1
Creating a function to auto hide rows 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hiding rows based on a cell? 3
Hide a sheet with a variable name 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Hide cell values based on a condition in another cell 1

Back
Top