# 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:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohammadarslan](https://avatars.discourse-cdn.com/v4/letter/m/d07c76/32.png) [@mohammadarslan](https://forum.dynamobim.com/u/mohammadarslan)\
**Post date:** [August 9, 2018, 9:42am UTC](https://forum.dynamobim.com/t/shading-rooms-using-csv-file-values/24640/1 "2018-08-09T09:42:23Z")

</div>

Hi,

I am trying to find some example that can be used to color the rooms using CSV file values. I have a building file in Revit and a CSV file with only two columns such as;  
Room 1, 5  
Room 2, 7  
And using the above values (5, 7), I am shading the rooms in different colors. If someone has any information, can you please share with me?

---

<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.

---

<div class="post-metadata">

**Author:** ![mohammadarslan](https://avatars.discourse-cdn.com/v4/letter/m/d07c76/32.png) [@mohammadarslan](https://forum.dynamobim.com/u/mohammadarslan)\
**Post date:** [August 9, 2018, 11:18am UTC](https://forum.dynamobim.com/t/shading-rooms-using-csv-file-values/24640/3 "2018-08-09T11:18:09Z")

</div>

Thank you for your reply 🙂
