Cell color

[Grant Reid]

Hi

Is there any function that will return the color and shading of a given
cell?

Any help would be much appreciated.

Many thanks - Grant

 

[Frank Kabel]

Hi
you need VBA for this. Using a user defined function. e.g.
for the colorindex try something like
public function color_index(rng as range)
color_index=rng.interior.colorindex
end function

note: not much error checking included, etc.
Call it on your worksheet with
=COLOR_INDEX(A1)