Color Fill Function

[Lynn]

Is there a function that will return the color fill value
of a cell?

 

[Chip Pearson]

You need to write a custom VBA function to do this. See
www.cpearson.com/excel/colors.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Frank Kabel]

Hi
something like
public function c_index(rng as range)
c_index=rng.interior.colorindex
end function

and in your worksheet use
=C_INDEX(A1)