Colour scalling bassed on values in ODS Excel

[krishnareddy1]

HI all, 

 I am trying to fill background with colours of columns based on their ranks  or values .  i  want colour scalling  like excel . can you plesse guyz help me. 

note: the values in column  will change even though  auto fill colours like colour scalling  like excel. 

thank you, 

regards,

 krishna reddy 

[Reeza]

You can use PROC REPORT for this. 

Here's an example:

http://support.sas.com/kb/54/675.html

ODS Excel documentation has an example of custom colouring as well:

https://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVe...

If you need further help, please provide more details about what you're trying to do and what issues you're having.

---

@krishnareddy1 wrote:

HI all, 

 I am trying to fill background with colours of columns based on their ranks  or values .  i  want colour scalling  like excel . can you plesse guyz help me. 

note: the values in column  will change even though  auto fill colours like colour scalling  like excel. 

thank you, 

regards,

 krishna reddy 

---