I need to highligh cells when they are = to another

[Eatcher]

Hey, i’m stuck on this for like 3 hours now, i really need help pls !

So i have numbers who can change between B2 and J9, and i want to know when they are the same between C10 and J11 like this :

Between B2 and B8 + C9 = Between C10 J11

Between B2 and B8 + between C2 and C8 + D9 = Between C10 and J11

Between B2 and B8 + between C2 and C8 + between D2 + D8 + C9 = Between C10 J11

And this until J9 !

I really need help pls, if u need more information i’m here !

[PKG]

Mettre en évidence une cellule si égal a une autre cellule, avec calcul

Bonjour, j’essaie de faire un Tableau depuis un moment mais je bloque sur une chose. Comme vous pouvez le voir, j’ai un tableau avec des données qui vont changé entre B2 et J8. Je voudrais que mes chiffres entre B2 et J8 soit en évidence si : Entre B2 et B8 + C9 = Chiffre compris dans les cellules C10 et J11 Entre B2 et B8 + entre C2 et C8 + D9 = Chiffre compris dans les cellules C10 et J11 Entre B2 et B8 + entre C2 et C8 + entre D2 + D8 + C9 = Chiffre compris dans les cellules C10 et J11 E…

[Lupp]

Sorry. I didn’t unbderstand the explanations.
Did you (@Eatcher) study this help page?
you will need ConditionalFormatting in formula-Is-mode. Start with creating the formula to use as the condition for an example in a helper cell, check if it works as expected, and transfer it then to the CF definition. Specifically regard where you need absolute or relative referencing.
If you have no clue concerning the terms I used, you will need to start with basic learning about Calc.
To get more specific help here, you may also create and attach a little example document with Calc where you entered some values into the cells, and give the wanted results (highlighting) by direct formatting for a small ,but sufficiently variable set of examples.

[Eatcher]

Ok thx i’ll try with the page !