custom formula is: "=COUNTIF($B1:$B100,"month")>1."

I tried also:


I know it shouldn't work but I test all that comes to my mind.

I paste this in a cell: =COUNTIF($B1:$B100,"month")>1 and returns TRUE. The formula is working, the conditional formatting isn't.

Any ideas?

  • tried also the formula without quotation marks – Manuel Ramirez Nov 6 '19 at 14:19
  • 1
    excel or google sheets? which version? this should work - there is nothing wrong in your logic – Oren Pinsky Nov 6 '19 at 18:14
  • Good point! it's google sheets, just updated the title to clarify it – Manuel Ramirez Nov 7 '19 at 14:56

In the end =COUNTIF($B1:$B100,"month")>1 worked, no quotation marks. I thougth I tried it before

  • I had the same issue even though the official help guide on this shows it with quotes around the whole thing, maybe just a formatting choice that causes confusion. – Matt Binford Jul 14 at 14:03

In your formula you have to omit the >1.
Your Conditional Formatting formula should be:


(The answer provided is in relation to your info. There is vital info missing from your question. I am not sure what exactly you try to achieve. Play around with the $ sign as well as the range and see your different results. Next time please do share a sample sheet. As always, as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well.)

  • conditional format responds to boolean only, =COUNTIF($B1:$B100,"month") returns a number, you MUST add >1 so the formula returns TRUE or FALSE. – Manuel Ramirez Nov 8 '19 at 16:36

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.