If you want to copy from one cell the "text" color, and paste the "color" to
another cell, then just click Ctrl C on the cell you want to copy from, and
the right click on the mouse on the cell you want to paste to and select
paste special. Select "format", that will paste the color from the original
cell to the new cell. Hope this helps. If you need more info, ask more
clearly, I might have not understood your question.

"mikenoak" wrote:

I want to set coloured traffic lights to highlight key results.
Please can some one tell me where I might find ideas as I can find no way to
copy text colours or change fonts as I copy from cell to cell