Cell color

  • Thread starter Thread starter Grant Reid
  • Start date Start date
G

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
 
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)
 
Back
Top