Forum Discussion
ahord05
Jul 29, 2019Copper Contributor
Multiple Conditional Formatting
I need to figure out how to do a conditional formatting with color fill and add text. Ex. If the formula in cell B5 gets deleted then I need the cell to turn blue and the cell to say "No Formula"...
SergeiBaklan
Jul 29, 2019Diamond Contributor
If the task is to check if in some cell formula was changed on value, when better to use conditional formatting rule with the formula
=ISFORMULA(B1)-1