You can use this method

http://tinyurl.com/eaquj


then use conditional formatting to change the colour of the cells

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"damorrison" wrote in message
oups.com...
I would like to highlite a range, then
click a button for an input box that asks for a value
then the rows with the cells that add up to that value(or as close to
it), will change to blue,
Has anybody an example of this or know of a way for this to be done??

Thanks
Dave