Hello everyone,

I have a Workbook with several different Sheets. All sheets are formatted exactly the same.

In the sheet I have a range B3:B15 - it contains one of three values - 2, 1, 0.
Based on this range I want to Hide specific columns and rows if value is equal "0" and unhide it if it is either "1" or "2".

For example:
If B3 = 0 Then Hide Column "F" and Hide Row "11", Else Show Column "F" and Show Row "11"

I want to create a Macros that will be constantly running and checking the values in the range or run itself as soon as a value in the range changes.