Here's a screenshot of the situation:


When I hover over the rule to the right which I defined, the wanted area is highlighted entirely, so I would presume I entered everything correctly, but only one cell actually assumes the wanted color (the one in the top left corner).

What do I have to do so that the entire area becomes green if B1="September" (which it is)

One more pic for clarification.

Any help is appreciated.


you need to lock it down with $ symbol otherwise:

  • cell F1 thinks that should look in C1 for September ...
  • and cell E2 thinks that it should look in B2 for September ...
  • etc.

correct it to this: =$B$1="September"

enter image description here

  • That's smart, thank you very much. – Karlo Grba Sep 4 '18 at 17:57

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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