I have a big list with 100 rows and 8 columns. In each of These 800 cells there is a value, either a direct Input (e.g. 23) or a formula to generate the value (formula would then be referring to at least one of these 800 cells).
In order to have a quick visual as to which cells are "overwritten" with direct Inputs and which have a formula behind them (so as to not so easily / accidently replace a formula with a value), I wish to Show all cells which contain a formula via italics text. Is this possible via conditional formatting?
It should be continuously / automatically recognised, e.g. not with a macro that I'd Need to run in order for all 800 cells to get checked and updated...
Bookmarks