Wed, 11 Jul 2007 17:38:01 -0700 from Lauryn
:
can you have the result return a color for a certain value? thanks!

If I understand what you want, then you would do it with a VLOOKUP
formula in the cell and conditional formatting based on the cell
value.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/