Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Is there a way, in Google Sheets, to have conditional formatting of some sort, to change the background color of a cell based on whether the cell contains a formula or a plain value?
red color for not formula & not empty:
yellow color for the formula detection:
bonus fact - showing a formula as text string:
Required, but never shown