Unprotected formula

Post Reply
Mimile
Posts: 11
Joined: Fri Jul 14, 2023 8:36 am

Unprotected formula

Post by Mimile »

Good morning,
I would like the cells in which there is an unprotected formula to be marked with a color mark, like in Excel. Is it possible ?
Thanks.
miguel-c
SoftMaker Team
SoftMaker Team
Posts: 1233
Joined: Wed Jun 05, 2019 12:02 pm

Re: Unprotected formula

Post by miguel-c »

You can do it with conditional formatting using the following formula:
=CELL("protect", INDIRECT(ADDRESS(ROW(),COLUMN())))=1
(replace "," with ";" if needed)

See the attached file where cell C4 is unprotected.
Attachments
unprotected.xlsx
(9.21 KiB) Downloaded 102 times
Mimile
Posts: 11
Joined: Fri Jul 14, 2023 8:36 am

Re: Unprotected formula

Post by Mimile »

Hello Miguel,
It works very well !
Thank you so much,
Cordially.
Post Reply

Return to “FreeOffice PlanMaker 2021 for Windows”