Forum Discussion

Copper Contributor

Jun 29, 2018

Solved

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...

Formulas & Functions

Need Help

Wyn Hopkins
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

MVP

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"

Ignacio Cano

Copper Contributor

Jun 29, 2018

Hi Wyn,

Thank you very much for your quick response. Sadly I'm using Excel 2010 and i've done something similar with macros but I will use your solution when I upgrade to Excel 2013.

Thanks!