I'm working on a spreadsheet, where I'm using COUNTIF to check the number of times a sheet range meets a criterion. This works.

I'd like to see which cells (their contents/locations) which met the COUNTIF criteria.

Specifically, the cells are strings not numbers.

  • sounds like conditional formatting to me
    – ale
    Jan 17 '19 at 2:40
  • if you need formula solution use ARRAYFORMULA():


    enter image description here

  • the best way is to use conditional formatting:


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.