I have a long sheet where some cells have typed values and some other cells have formulas. And i need to have a visual identification of the kind (number or formula) of each cell.

Is it possible to do by using conditional formatting? If yes, how?

Many thanks in advance.

  • Might this be an option? => Libreoffice menu:View > Show formula (CTRL+`). The same is available in Excel, but I do not remember where (the shortcut is CTRL+SHIFT+D if I remember correctly) – Hannu Aug 7 at 19:49
  • Thank you. This doesn't solve completely my problem but helps a lot. – Marcelo Aug 9 at 13:02

It actually is relatively simple using the ISFORMULA function, available since Excel 2013.

  • Select your range
  • New conditional formatting formula, e.g:

  • Apply your formatting

  • Confirm

enter image description here

Prior to Excel 2013, you may want to use a custom function.

  • Paste this code in a module:

    Function ISFORMULA(ByVal target As Range) As Boolean
        ISFORMULA = target.HasFormula
    End Function
  • Repeat the exact same steps as the above example

  • Thank you, but my Excel is 2010... – Marcelo Aug 9 at 13:01
  • @Marcelo, edited – JvdV Aug 9 at 13:12
  • 1
    Worked! Thank you very much! – Marcelo Aug 12 at 13:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.