Managing 50+ colors doesn't seem very workable whether you use conditional formatting or some other method.
Perhaps you need a second portal that only shows records for a specified discharge? A "master-slave" pair of portals comes to mind, where you click a record in portal 1 and this click then changes what records appear in portal 2--such as showing all records from the first portal that have the same discharge ID as that of the portal row that was clicked.
you're probably right, although only a few sites have so many discharges. Most have two to four. Anyway, I already have a filter button setup so I can select only the documents that pertain to a specific discharge. It's just nice to see them all together but highlighted. Thanks for the advice.