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 cells with formula_Y and 3 cells with a number. How to use condicional formating to fill with 3 different colours depending on formula_X, formula_Y or value?

Excuse me for my English but it is not my first language.

 

Thanks!

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"

2 Replies

  • 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