How to make an Excel (Calc) file with forms and checks?

Question

excel

It is necessary to prepare a list of names with characteristics. Part of the characteristics depends on the group to which the name belongs, part must have a check, for example, dimensions.
That is, we enter the name "Orange", indicate its group "Fruit" and the columns of Characteristics that must be filled in for the group "Fruit" are immediately highlighted. When filling in a characteristic, for example, Weight, you cannot specify more than a kilogram. Well, etc.

How to implement this? At the output, you need an excel sheet, csv, ods - it doesn't matter.

Answer 1

Use conditional formatting, create a rule for each characteristic for each group.
Main - Conditional formatting - Create a rule... - Use a formula to determine the cells to be formatted
And there write something like:
=ДВССЫЛ("RC2";0)="Фрукты"
2 - the number of the column to be checked. If this column contains "Fruit", then the cells in this row will apply the format that you specify in the rule.
But given that multiplication of sets is obtained here, then a lot of rules will have to be done. (10 categories * 10 characteristics = 100 rules)