Hiding rows based on a certain cell's value which is a formula

Thank you for the reply. I used this code but was unsuccessful. I am getting the RunTime Error '1004': Unable to set the Hidden property of the range class. I had tried the if then statements before and got this error.