| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
set conditional traffic lights depending on adjacent cell value
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 .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating on rows & cols depending on one cell | Excel Discussion (Misc queries) | |||
| Conditional formatting depending a range of cell | Excel Worksheet Functions | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
| How do I use traffic lights in excel | Excel Discussion (Misc queries) | |||
| How do I get traffic lights in excel that change colour | Excel Worksheet Functions | |||
Threaded Mode
