Revalidate all cells validation on any change

[SiRCYRO]

I've got many cells with validation set up, but the validation is dependent on other cells in the worksheet which can change.

The validation works as long as I go through each cell systematically, but if I'm at the bottom and change one value in an earlier row, the other cells aren't re-validated. Is there a way to force the worksheet to re-validate any cell that has validation upon any change in the worksheet?

[bentleybob]

Other than by VBA, I'm not aware of anything that will do what you're specifically asking for. However, you can easily use conditional formatting to highlight cells that are no longer within the validation constraints. Is that a viable option for you?

[SiRCYRO]

That's actually a good idea, it won't give you a popup but it's better than nothing. Thanks for the tip!