Forum Discussion

Ignacio Cano's avatar
Ignacio Cano
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's avatar
    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's avatar
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's avatar
    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!

Resources