set conditional traffic lights depending on adjacent cell value

[mikenoak]

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

 

[art]

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.

 

[Max]

Try Conditional Formatting using Formula Is, with the CF formulas pointing to
the particular col's value using the "$" sign

Eg, Supposing col A is to be formatted based on col B values
Select col A (A1 active), then apply the CF as, say:
Cond1: =$B1<1
Format: red
Cond2: =and($B1>=1,$B1<5)
Format: amber
Cond3: =$B>=5
Format: green
Ok out, then test it ..