New Contributor

# highlight values which summed are equal to a predefined data

Hello,

I have this problem and a solution would help me a lot by saving time.

pls look at below example

sheet 1:

 name received order nr ana 20 aaa ana 12 bbb ana 10 ccc david 10 ddd david 11 eee david 12 fff david 12 ggg

shhet 2:

 name total ana 32 david 24

I need a function that can highlight the values in sheet 1 which summed are equal to the values in sheet 2.

thank you

5 Replies

# Betreff: highlight values which summed are equal to a predefined data

In your picture, for example, you cannot see where the words "Ana, David, etc." takes the value.
It is not clear what your plan is.
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

Thank you for your understanding and patience

Wish you a nice day.

Nikolino
I know I don't know anything (Socrates)

# Betreff: highlight values which summed are equal to a predefined data

@Nikolino , I really am grateful to your reply and suggestions, but I still think that putting the files up here won't make any difference.

pls see my problem like this

I have a sum of 32 \$ ( the number in sheet 2 ) and I need to close to Ana only the orders ( sheet 1 ) which summed are 32

how can I highlight the orders that will close that number in the second sheet, for every entity ana, david,....etc?

# Betreff: highlight values which summed are equal to a predefined data

For me it would have made a lot of sense to have a file to understand what exactly you want. please also understand that we as humans do not understand everything. As in your case, I unfortunately can't understand how you get 32 when you add 42 to Ana. Anyway I can't help you without a file. Perhaps one of the professionals will contact you here, who certainly know more than an ignorant person like it is, and give you the desired solution.

Wish you a nice day.

Thank you for your understanding and patience

Nikolino
I know I don't know anything (Socrates)

# Re: highlight values which summed are equal to a predefined data

The main problem would appear to be knowing what to highlight; the formatting is the trivial part!

# Re: highlight values which summed are equal to a predefined data

thanks a lot Peter, this is what I need.