Hello, I currently have the top table in excel from proc print ods excel output. The only column I want to focus on is the last column "DESC". I want the rows to alternate colors based on description. See second table for an idea of the output I want. I couldnt include color fill on here, so I bolded the font to illustrate. But what I want really is the first two rows should be say blue, then since description on row 3 changes it is now grey, row 4 also grey, then row 5,6,7 are back to blue. and so on and so forth. I have no idea how to start this. Obviously, the data set is much larger, so doing it manually in excel would be time consuming. Was wondering if proc report would be the place to start and how? id INITIALS code var2 START_DATE DESC a GT 1 na 17Nov2023 h a GT 1 na 17Nov2023 h a GT 1 na 17Nov2023 c a GT 1 na 19Nov2023 c b hi 1 . 22Nov2023 d b hi 1 . 10Nov2023 d b hi 1 10Nov2023 d a GT 1 . 10Nov2023 f id INITIALS code var2 START_DATE DESC a GT 1 na 17Nov2023 h a GT 1 na 17Nov2023 h a GT 1 na 17Nov2023 c a GT 1 na 19Nov2023 c b hi 1 . 22Nov2023 d b hi 1 . 10Nov2023 d b hi 1 10Nov2023 d a GT 1 . 10Nov2023 f
... View more