Is there a function that will return the color fill value of a cell?
C Chip Pearson Aug 4, 2004 #2 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
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
F Frank Kabel Aug 4, 2004 #3 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)
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)
