I'm trying to have cells which value has been entered manually and cells that are the result of a formula differently, is there a way to do that?

migrated from superuser.com Jan 23 at 21:20

This question came from our site for computer enthusiasts and power users.

  • custom formula: =ISFORMULA(A1) or: =IF(NOT(ISBLANK(A1)), (NOT(ISFORMULA(A1))))


  • Thanks for your answer, but I want to format all cells in the sheet. With this solution I can only make one column at a time (for instance by selecting column A and writing =ISFORMULA($A1)). For the whole sheet I wouldn't know what to put into the brackets. – kaleidoscop Jan 24 at 6:32
  • @kaleidoscop you will put the same but you will apply it to the whole range. eg instead of A1:A, type in A1:Z – user0 Jan 24 at 12:13

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.