You will have to give us a little more information, it can be done with
macros, data validation (if you choose the colour from a drop down
list), but depends on the data you wish to return, and if the data will
be added to in future or is always the same information

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=544968