Hide cell if certian cells equal a certian criteria

Hello,
How would you change cell I16 if row 16 is hidden?

What do you mean by "hide"? You can't hide cells, you can only hide entire rows. You can modify your formulas so that blanks are shown in B:F when I is "--". Is that what you mean? See attached for an example.

You are using "$" unnecessarily on row numbers in formulas in B:F. This prevents formulas from being copied downwards. I have removed this.

You are using SUM with only one value as an argument. This is not harmful but unnecessary and adds clutter, so I have removed it.

(If you want to truly hide the row, that can be done with macros, but then you can't see the dropdown anymore to change it.)

You can't hide cells, but you can change the color of the font to white. That would almost be the equavilent.
Add this to your code;

Please Login or Register  to view this content.

Namluke,
Take a look at the file 6StringJazzer gave you. He changed the formulas in column B so that the text hides when column I of the same row is equal to "--"

Seems like this is the solution you need, rather than VBA.