Roz
You can use formulas to return values from shaded cells but you must employ
VBA.
See Chip Pearson's site for Functions.
http://www.cpearson.com/excel/colors.htm
Note the caveats about CF shaded cells.
Gord Dibben MS Excel MVP
On Wed, 24 Jan 2007 01:18:50 -0800, Roz wrote:
In Excel I want to link to cells that contain shading rather than data. Does
anynoe know if/how this can be done?