color the cells conditionally

mona4u — Wed, 27 Jun 2018 14:33:41 GMT

Hi,

I have this project and

I want to know if I would have the ability to color the cells by using SAS. For example, if the billed to date is more than 75% the cell color should be red and delta is less than %25 also the cell color should be red.

otherwise, it should be green.

Can you show me how a brief example of that if there is a way to do this???

Re: color the cells conditionally

RW9 — Wed, 27 Jun 2018 14:53:58 GMT

Yes, it is called traffic lighting and there are loads of papers on it for instance:
http://support.sas.com/resources/papers/proceedings11/290-2011.pdf

topic color the cells conditionally in ODS and Base Reporting

color the cells conditionally

Re: color the cells conditionally