# Conditional Format Excel not working (Bumblebee package)

**URL:** <https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295>\
**Category:** Packages\
**Tags:** bumblebee\
**Created:** [June 6, 2017, 12:31pm UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295 "2017-06-06T12:31:26Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zaara-786](https://avatars.discourse-cdn.com/v4/letter/z/977dab/32.png) [@Zaara-786](https://forum.dynamobim.com/u/Zaara-786)\
**Post date:** [June 6, 2017, 12:31pm UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/1 "2017-06-06T12:31:26Z")

</div>

Hi all,

I am trying to format one range of my Excel with one Format condition. The Dynamo node returns “Success !” but nothing is happening in Excel.  
What am I doing wrong?

Here is what I did:

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/9/998e5800e2c4f87e3cfb55ee0f7aa1278cc8b32d.png)  
 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/2/324902a86c1a8167ce67ca3382aa4d22e109a286.png)

Thanks for your help

---

<div class="post-metadata">

**Author:** ![MJB-online](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mjb-online/32/24884_2.png) [@MJB-online](https://forum.dynamobim.com/u/MJB-online)\
**Post date:** [June 9, 2017, 7:57pm UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/2 "2017-06-09T19:57:10Z")

</div>

Hi Zaara,

I’m sorry i have no experience with Bumblebee, but have you seen this [picture](https://raw.githubusercontent.com/ksobon/BumblebeePrimer/master/cellValue6.png) on this [page](https://github.com/ksobon/BumblebeePrimer)?  
Maybe the above links can help you to solve your problem.

Kind regards,  
Mark

---

<div class="post-metadata">

**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\
**Post date:** [June 10, 2017, 1:15am UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/3 "2017-06-10T01:15:55Z")

</div>

Use Background Color not the Pattern Color. You are using a solid fill. Solid fill is applied to background, not the pattern lines.

![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/a/3ae1b82542be8e9911212fd0f04dce26602ace89.png)

If you used diagonal lines then you need to specify the pattern color (line color), and optionally a background color.

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/4/944b08a85c4f6cc341026909c66930929ff229fc.png)

---

<div class="post-metadata">

**Author:** ![Zaara-786](https://avatars.discourse-cdn.com/v4/letter/z/977dab/32.png) [@Zaara-786](https://forum.dynamobim.com/u/Zaara-786)\
**Post date:** [June 12, 2017, 9:18am UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/4 "2017-06-12T09:18:38Z")

</div>

Thanks @Konrad_K_Sobon,  
But still not working :s

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/8/98091b02fb8fbf39ebba6b238bf0a38a8f9079d2.png)

---

<div class="post-metadata">

**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\
**Post date:** [June 12, 2017, 12:41pm UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/5 "2017-06-12T12:41:26Z")

</div>

Try it exactly like in my image. No FilePath input, keep the excel file open. It might be a FilePath issue.

---

<div class="post-metadata">

**Author:** ![Zaara-786](https://avatars.discourse-cdn.com/v4/letter/z/977dab/32.png) [@Zaara-786](https://forum.dynamobim.com/u/Zaara-786)\
**Post date:** [June 12, 2017, 2:03pm UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/6 "2017-06-12T14:03:43Z")

</div>

It works !! Thanks @Konrad_K_Sobon It was a FilePath issue as you said 🙂

---

<div class="post-metadata">

**Author:** ![sps.25788](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sps.25788](https://forum.dynamobim.com/u/sps.25788)\
**Post date:** [January 19, 2018, 10:59am UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/7 "2018-01-19T10:59:08Z")

</div>

Can we add two different values to the cell value format condition? I want to add 2.5 and 3.5 along with 5 in code block.

 ![Conditional Format](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/2/824df0e365b4c5b87bc35d58481a696d8b855a75.JPG)

---

<div class="post-metadata">

**Author:** ![madmax1992](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@madmax1992](https://forum.dynamobim.com/u/madmax1992)\
**Post date:** [July 2, 2019, 4:03pm UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/8 "2019-07-02T16:03:03Z")

</div>

Hi Konrad!  
Sorry but in my case don’t works… I try with the excel close and the file path input on, and with the excel open and the file path input off…  
In the second case the output makes an error…!

 ![Cattura](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/9/d9cbe8b1c3c69e45633488e95ec43db9af662711.png) ![Cattura2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/a/2a8dd58abde4c69aeff9ef37def669bd36e8e35b.png) ![Cattura3](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/0/a0d9d1b786acef9ca2108e8e923bcb5aa01d4c84.png)

---

<div class="post-metadata">

**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\
**Post date:** [July 2, 2019, 5:13pm UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/9 "2019-07-02T17:13:14Z")

</div>

Please open a new issue. This one was solved. Also you will need to post a Dynamo and Excel files, plus some info about what versions of the plugin you are using etc. Please read the guidelines on how to ask questions. It helps those trying to answer them.

Cheers!

---

<div class="post-metadata">

**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\
**Post date:** [July 2, 2019, 5:13pm UTC](https://forum.dynamobim.com/t/conditional-format-excel-not-working-bumblebee-package/12295/10 "2019-07-02T17:13:18Z")

</div>


