Conditional Formatting not recalculating

C

CH

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top