Hello,
I'm trying to solve the following without VBA:
Unbenannt.JPG
The left side is the total of the right side.
Now I'm trying to highlight the right cell group if the summation is not equal to the total on the left side.
Actually that's not hard to achieve, but I want that it automatically detects his left side parent. If that would be kind of possible then I could set the formula for the whole column.
My idea is:
- get the parent cell (at D3 it would be B3, at D4 it should be B3)
- subtract the cell value from the parent cell and put it at the parent row at e.g. F3
- in the first case it should does the steps above 3 times; then if F3 is not zero D3, D4, D5 should highlight in red.
BUT I don't know if it's even possible, because I couldn't find even the first step.
Bookmarks