# Shading rooms using CSV file values

**URL:** <https://forum.dynamobim.com/t/shading-rooms-using-csv-file-values/24640>\
**Category:** Revit\
**Tags:** revit, excel, geometry, dynamo\
**Created:** [August 9, 2018, 9:42am UTC](https://forum.dynamobim.com/t/shading-rooms-using-csv-file-values/24640 "2018-08-09T09:42:23Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\
**Post date:** [August 9, 2018, 10:24am UTC](https://forum.dynamobim.com/t/shading-rooms-using-csv-file-values/24640/2 "2018-08-09T10:24:16Z")

</div>

From the provided information I would do the following:

1. Get Rooms in Revit
2. Group by room number
3. Read .csv (remember to read values as numbers and strings as strings).
4. Transform “color-code” to actual color value/override
5. Compare rooms with color-overrides
6. Apply override to Rooms.

---

_[View the full topic](https://forum.dynamobim.com/t/shading-rooms-using-csv-file-values/24640)._
