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.
Unprotected formula
Re: Unprotected formula
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.
=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 408 times