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.


1 Answer 1


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
    Commented Sep 4, 2018 at 17:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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