# Transferring Existing Conditional Formatting to Excel

**URL:** <https://forum.dynamobim.com/t/transferring-existing-conditional-formatting-to-excel/80861>\
**Category:** Revit\
**Tags:** bumblebee, excel, schedule, dynamo, export\
**Created:** [September 9, 2022, 12:09pm UTC](https://forum.dynamobim.com/t/transferring-existing-conditional-formatting-to-excel/80861 "2022-09-09T12:09:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Piero](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/piero/32/146135_2.png) [@Piero](https://forum.dynamobim.com/u/Piero)\
**Post date:** [September 9, 2022, 12:09pm UTC](https://forum.dynamobim.com/t/transferring-existing-conditional-formatting-to-excel/80861/1 "2022-09-09T12:09:17Z")

</div>

Hey all,

Wondering if anyone knows if the ability to harvest information on existing conditional formatting on a schedule within Revit to transfer to an Excel sheet exists.

I’ve been playing around with the Bumblebee in Dynamo and my concern is that formatting a schedule wouldn’t have the same result on different schedules with different formatting settings and different amounts of cells because Bumblebee’s conditional formatting settings seem pretty specific.

If anyone knows if these settings within Revit are accessible somehow through a different package or preferably the API feel free to point me in the right direction.

Thanks!

---

<div class="post-metadata">

**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\
**Post date:** [September 9, 2022, 12:50pm UTC](https://forum.dynamobim.com/t/transferring-existing-conditional-formatting-to-excel/80861/2 "2022-09-09T12:50:22Z")

</div>

@Piero ,

the regular export happened as .txt. I would recoment to prepare a well exceltemplate and load the .txt via Data into it.

KR

Andreas

---

<div class="post-metadata">

**Author:** ![Piero](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/piero/32/146135_2.png) [@Piero](https://forum.dynamobim.com/u/Piero)\
**Post date:** [September 9, 2022, 1:26pm UTC](https://forum.dynamobim.com/t/transferring-existing-conditional-formatting-to-excel/80861/3 "2022-09-09T13:26:28Z")

</div>

Hey @Draxl_Andreas,

I get what your saying to work with the data in a “.txt” file which is out of the box Revit export, but that doesn’t give me information on **Conditional Formatting** that is existing within that schedule in Revit. I have a Dynamo script that exports my schedule I want to Excel. The feature I want to add to it is it formats the excel schedule exactly like how it is in Revit. I would prefer to fully automate this task instead of manually making excel templates to just copy formatting that already exists in Revit.

Based on my research so far I don’t know if harvesting that existing data from Revit is possible.

---

<div class="post-metadata">

**Author:** ![GavinNicholls](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gavinnicholls/32/190442_2.png) [@GavinNicholls](https://forum.dynamobim.com/u/GavinNicholls)\
**Post date:** [September 12, 2022, 1:03am UTC](https://forum.dynamobim.com/t/transferring-existing-conditional-formatting-to-excel/80861/4 "2022-09-12T01:03:07Z")

</div>

I second the better approach of building a template and copying the data into it. From what I can see, there isn’t API for conditional formatting exposed on the Microsoft docs, so it might not be automateable.

Suggest searching through it to see what you can find:

> **[Microsoft.Office.Interop.Excel Namespace](https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel?view=excel-pia)**
>
> Explore all classes and interfaces of the Microsoft.Office.Interop.Excel namespace.

Given it’s a range associated object it would be best to look at those, as I’m unsure if it would be a cell property if it were exposed.

---

<div class="post-metadata">

**Author:** ![Piero](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/piero/32/146135_2.png) [@Piero](https://forum.dynamobim.com/u/Piero)\
**Post date:** [September 12, 2022, 5:27pm UTC](https://forum.dynamobim.com/t/transferring-existing-conditional-formatting-to-excel/80861/5 "2022-09-12T17:27:22Z")

</div>

Hey @GavinNicholls,

Thanks for your response and for sending that resource. I’ll take a look at it and see if we find a solution hopefully to automate this. I’ll send our findings (if any) to this post.