Any chance of seeing a packaged workbook so we can see how you've built this, how your data is structured, etc?
Ultimately, you should just be able to drop a dimension on the color card, but difficult to tell you which one to drop on it without seeing the data. You'd probably need to create a calculated field...something like:
If [Your Dimension] = "Prime, Single Award" THEN
I would ideally just like to change the row shading on 5 different rows; instead of changing the shading for multiple or groups of rows.
Can you provide a sample workbook?