1

Here's a screenshot of the situation:

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.

0

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 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.