highlight cells based on a value of another cell

[jayrocco]

Hi,

I have a column with random numbers, I need to highlight the cells that make up total amount of 33.

Example below... add up to 33... how do I do a range formula and highlight the cells that make up 33, I need to then color code those cells.. (Hope this is clear!) thanks,

COLUMN
10
7
6
7
8
5
6
4
8
1
4

[DavidBowman]

There are several combinations of numbers in that list that can total 33. Yes the ones you highlighted but also for example:
7
6
7
5
4
4

So how many combinations equaling 33 do you want out of the list? Are there any other parameters that had you identify the numbers you highlighted?

[jayrocco]

thank you for your reply.

it doesnt matter, is there a way of just highlighting any combination to add up to 33?

thanks

[DavidBowman]

What is confusing me is how to highlight them. If you considered all combinations all of the numbers would be highlighted.