Hi, I am trying to create a set of reports that needs to be color coded (background) based on a range of values that I have already grouped. I have successfully colored the rows the correct colors based on the values but I really need to highlight only two of the columns, not all of them. I have tried many different ways to color indiviudal columns, but it only worked with all rows. Here is my code for one of the reports (that works to color the rows): proc report data= comp nowd spansrows style= {background= white foreground=black }; column title unit class count month percent; define title/ order=data ; define unit/ order=data ; define class/ order=data ; define count/ order=data ; define month/ order=data ; define percent/ order=internal ; /* hidden column containing color flag*/ column category; /* dummy column for traffic lighting*/ column dummy; define category/ display noprint; /* traffic light the data columns based on category*/ define dummy/ computed noprint; compute dummy; if category in (1,2,3,4) then call define (_row_), 'style', 'style= {background=' || put (category, colorflag.)']'); endcomp; run; The category variable is 1-4 based off of the percent values. and the format 'colorflag.' is (1=red, 2=orange, 3= yellow, 4=green). As previously stated, this code works for coloring all rows but I only want title and percent to be colored based off of the category. Changing "_row_" has been unsuccessful, so if anyone has any ideas, I'd really appreciate it! - Chelsea
... View more