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?

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


| improve this answer | |
  • 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 '19 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 '19 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.