Color range if sum equal to specifc value

[YasserKhalil]

Hello everybody
I have numbers in range("A2:A" & lastrow)
In D3 I have a number which is considered the sum of some values in range("A2:A" & lastrow)

Here's an attachment to illustarte the expected results

[zbor]

Here, try this:

Please Login or Register  to view this content.

Use function as:

Please Login or Register  to view this content.

Where first range (A1:A100) is SUM range and second cell (A10) is criteria for color you want to sum.

[sktneer]

Not sure exactly what you are trying to achieve.

In col. A, have you colored the range A7:A14 because the Sum(A7:A14) is equal to D3 i.e. 42?
If yes, then why not A4:A13 because sum of this range is also equal to 42?

You may try this to see if this is what you are trying to achieve.

Please Login or Register  to view this content.

[YasserKhalil]

Mr. zbor
Thanks for this nice and useful function .. but it is not required here

Mr. sktneer
Great solution and very good ..
I wondered is there a way to extract the different possibilties to adjacent columns ..

[sktneer]

To extract the possible sum ranges in adjacent columns, you may try this.....

Please Login or Register  to view this content.

[YasserKhalil]

Mr. sktneer
This is the most perfect solution for my request
Thanks alot for this great help

[sktneer]

You're welcome Yasser!
Glad I could help and thanks for the feedback as well.