Traffic lighting has been around for a long time and is easy to do with ODS. However, it is not dynamic. Once ODS makes the background of the cell yellow, for example and the output gets to Excel, then the background of the cell will stay yellow, even if the values in the cell get changed. If this is what is desired, then the first ways to explore trafficlighting are through the use of PROC FORMAT with PRINT, REPORT and TABULATE. And then for more complex trafficlighting, PROC REPORT uses CALL DEFINE within a COMPUTE block. Cynthia
... View more