You can do this by using this addin :
https://apps.autodesk.com/RVT/en/Detail/Index?id=2938312742466834126&appLang=en&os=Win32_64
It's free,
Check this screenshot, I've selected the rooms according to their departement for example, however this doesn't work inside schedules, but I would expect that the addin will serve your needs, as if you selected your targeted rooms, you can do what's in your head with them, unless you want something else, like coloring the cells in the schedule, it won't help you in this case, you would need conditional format abilities (If this is what you want, just reply) to tell you the details of it if you're unaware of it,