From the provided information I would do the following:
- Get Rooms in Revit
- Group by room number
- Read .csv (remember to read values as numbers and strings as strings).
- Transform “color-code” to actual color value/override
- Compare rooms with color-overrides
- Apply override to Rooms.