How to hide rows with macro if another cell is not blank?

[Salzano14]

Hello and thanks advance for any help you can provide!

I have a pretty simple thing I need to do, but my macro-writing skills are basically nonexistent.

I have a cell, A163, that has a formula in it. When certain criteria happens, the cell reads a warning, when that criteria is not met, the cell is blank (double quotes "" to be exact). Simple IF formula, basically =IF(A1=1,"WARNING","")

I'm looking for a way to hide rows 474 to 536 when cell A163's formula results in a blank.

Any ideas? Hopefully this is easy!

[davesexcel]

You can set a condition, so if A163="" then hidden rows will be true and if it does not ="" then hidden rows will be untrue.

Please Login or Register  to view this content.

[Salzano14]

You can set a condition, so if A163="" then hidden rows will be true and if it does not ="" then hidden rows will be untrue.

Please Login or Register  to view this content.

YES, that did it, thank you!