Cell Formulas | ||
---|---|---|
Range | Formula | |
A1 | A1 | =ISFORMULA(A1) |
A7 | A7 | =ISFORMULA(A1) |
A14 | A14 | =ISFORMULA(A1) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A1:A14 | Expression | =ISFORMULA(A1) | text | NO |
=GET.CELL(41,INDIRECT("rc",FALSE))
=LEFT(HasFormula)="="
Thank you so much !In the name manager create a new name ( I called it HasFormula) and in the refers to box putthen you can useExcel Formula:=GET.CELL(41,INDIRECT("rc",FALSE))
in conditional formattingExcel Formula:=LEFT(HasFormula)="="
For this to work it needs to be a macro enabled file & macros need to be enabled.