How to identify/reproduce a Fill colour

[Motox]

Hi,

If there is a colour in a cell that I want to use in another cell how can I find what the colour is, and/or copy it to the new location?

Sometimes a colour other than those available as a "standard" colour is used and it is almost impossible to match it by trial and error.

I realise that the Format Painter can be used but I often just want the colour only and not have the rest of my format altered.

Thanks very much

Dave

[alansidman]

Here are two UDF's that you can use to get the color codes.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[nsv]

As for the first part of your question, how to find what the color is, this method is perhaps the most easy: put the cursor on the cell - right click - format cells - fill - more colors - user defined.

NSV