Hi All

I need to be able to colour cells in a range that total a specified value,
plus, if possible add some notification to tell the user if the specified
value can't be matched exactly.

EXAMPLE:
If the specified value is 20, only cells A1:A3 would be coloured or
if the specified value is 40 cells A1:A4 would be coloured with a message
box to say that 40 couldn't be matched.

A
1 10
2 5
3 5
4 10
5 20

Any help would be appreciated.

Thanks

Trevor