I'm trying to use Conditional Formatting for a really simple task:
- color cells if they have the same value as a specific another cell.
But I'm getting unexpected results when setting the range to apply!
- Formatting rule: format cells if
is equal to
=G35
; (background color)
When setting the range, I made these tries, which are over 2 cells that have the exact same value as G35:
- Apply to Range:
I7
→ I7 is colored green, just as expected; - Apply to Range:
I7,O8
→ only I7 is colored green, O8 is not. I expected both to be colored; - Apply to Range:
O8,I7
→ only O8 is colored green, I7 is not. I expected both to be colored.
I would like to understand where is there error on my thought. Can someone please explain?
Here is the screenshot of the rules, as explained above: