I have an excel file that has selection boxes (boxes set up as lists using
the data validation feature). I have set conditional formatting to hide
certain selection boxes based on cell values. The problem is that the
conditional formatting does not automatically recalculate as needed when cell
values change.

Any thoughts on how to fix this?