Color marking of cells through checkboxes

[Aeris]

Hi Hi,

In Google Sheets, I have functions through checkboxes, but when I convert the project to an .ods file, the functions are not preserved.

TEST23

https://streamable.com/dskqcg

How can I keep these functions in the .ods file or create exactly the same?

thanks

[Zizi64]

Link the checkbox state to the cell where it is located: true/false, 1/0

Then apply Conditional Format property for the data cells based on the checkbox values.