Regarding your example, you can protect worksheets and have only some cells unlocked for modification [1].
You can add conditional formatting, VBA procedures, additional formulas etc. to do whatever validation you like. However, you need a software engineer (or someone who thinks like one) to properly implement that, and it’s not exactly fun.
[1] https://support.microsoft.com/en-us/office/lock-or-unlock-sp...