Highlight cells in a SAS dataset so that it is highlighted when exported to Excel

[mzhao2]

Hi SAS communities,

I currently have a script that exports SAS datasets to Excel using proc export. However, I need to highlight the maximum absolute values for some variables and this formatting needs to be there when the dataset is exported to an Excel file. I was wondering what is the best way to approach this?

Thanks!

[Reeza]

ODS EXCEL + PROC REPORT for traffic lighting. 

This paper covers it in detail, and has a specific traffic lighting example starting on page 7.

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2765-2018.pdf