The SAS Output Delivery System and reporting techniques

color the cells conditionally

Accepted Solution Solved
Reply
Regular Contributor
Posts: 165
Accepted Solution

color the cells conditionally

 

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??? 

Capture1234.PNG


Accepted Solutions
Solution
‎06-27-2018 12:18 PM
Super User
Super User
Posts: 9,799

Re: color the cells conditionally

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

View solution in original post


All Replies
Solution
‎06-27-2018 12:18 PM
Super User
Super User
Posts: 9,799

Re: color the cells conditionally

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 96 views
  • 1 like
  • 2 in conversation