Conditional Hide... Please Help!

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

Guest

I am trying to make a conditional hide with the following statement:
=IF($I14="CONST","Show","Hide")
Is there a way to add another condition to the same row? I need excel to
hide "#VALUE!" as well. I tried =IF($I14<>"CONST","Hide","Show"), but this
will not pick up the "#VALUE!" cells. Is there a way to add to the statement
so I can include both?
Any help is greatly appreciated.
Thanks,
JRG
 

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 cell unless value entered into any cell on a row 3
Text treated as a numeric value? 4
Conditional Formatting I can't seem to figure out...... 2
Hiding rows 1
Hide rows with conditional formatting 5
IF / Vlookup formula 3
Conditionally hiding rows 1
Hide and Show Rows based on Cell Value 2

Back
Top