Forum Discussion
Ignacio Cano
Jun 29, 2018Copper Contributor
Conditional Formating by formula, not by value
Hi everyone, I would like to use conditional formating in a few cells but not depending on their value but on their formula. For example, from cell A1 to A10 there 3 cells with formula_X, 4 cel...
- Jun 29, 2018
Hi Ignacio
If you have Excel 2013 or above you could use the formula =FORMULATEXT in your conditional formatting
E.g. =FORMULATEXT(D7)="=A1"
Wyn Hopkins
Jun 29, 2018MVP
Hi Ignacio
If you have Excel 2013 or above you could use the formula =FORMULATEXT in your conditional formatting
E.g. =FORMULATEXT(D7)="=A1"