G Guest Jan 24, 2007 #1 In Excel I want to link to cells that contain shading rather than data. Does anynoe know if/how this can be done?
In Excel I want to link to cells that contain shading rather than data. Does anynoe know if/how this can be done?
G Gord Dibben Jan 24, 2007 #2 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
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
