# Colour Cell in Excel using Bumblebee

**URL:** <https://forum.dynamobim.com/t/colour-cell-in-excel-using-bumblebee/66766>\
**Category:** Uncategorized\
**Created:** [August 3, 2021, 8:13am UTC](https://forum.dynamobim.com/t/colour-cell-in-excel-using-bumblebee/66766 "2021-08-03T08:13:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mitchellpUDG9S](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@mitchellpUDG9S](https://forum.dynamobim.com/u/mitchellpUDG9S)\
**Post date:** [August 3, 2021, 8:13am UTC](https://forum.dynamobim.com/t/colour-cell-in-excel-using-bumblebee/66766/1 "2021-08-03T08:13:36Z")

</div>

Hi everyone,

I would appreciate any help in how to colour a cell/range of cells in Excel. My goal is to get the entire top row to have a specific colour, but I cannot get it to work. For now I am just trying to get colour to appear in one cell.  
I have had a look at the Bumblebee primer, but I cant find any info on there on how to actually apply the colour to the cell. I have created a solid fill style for the background colour (I think), and now am trying to apply it to the file, could any one point out what I have to do here?

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

---

<div class="post-metadata">

**Author:** ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts)\
**Post date:** [August 3, 2021, 3:56pm UTC](https://forum.dynamobim.com/t/colour-cell-in-excel-using-bumblebee/66766/2 "2021-08-03T15:56:14Z")

</div>

Watch the input and output types between bumblebee nodes. They should all match. Right now you’re using a conditional formatting node (`FormatConditions` input) with a `GraphicStyle` output. Switch out `Conditionally Format Excel` for the `BB Style` and `Format Excel` nodes.

---

<div class="post-metadata">

**Author:** ![Deniz\_Maral](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/deniz_maral/32/80323_2.png) [@Deniz\_Maral](https://forum.dynamobim.com/u/Deniz_Maral)\
**Post date:** [August 3, 2021, 6:12pm UTC](https://forum.dynamobim.com/t/colour-cell-in-excel-using-bumblebee/66766/3 "2021-08-03T18:12:43Z")

</div>

What condition would you like to have? Add it also there and lastly you need a valid range. Only A1 for conditional formatting means: the rule will be applied only for A1 cell.

---

<div class="post-metadata">

**Author:** ![mitchellpUDG9S](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@mitchellpUDG9S](https://forum.dynamobim.com/u/mitchellpUDG9S)\
**Post date:** [August 4, 2021, 5:52am UTC](https://forum.dynamobim.com/t/colour-cell-in-excel-using-bumblebee/66766/4 "2021-08-04T05:52:16Z")

</div>

Hi Nick,

Perfect, that worked exactly as I wanted it to, thank you!  
My “Format Excel” node had an invalid input, which was the BBStyle, that’s why I never caught it, thank you for this!

---

<div class="post-metadata">

**Author:** ![mitchellpUDG9S](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@mitchellpUDG9S](https://forum.dynamobim.com/u/mitchellpUDG9S)\
**Post date:** [August 4, 2021, 5:53am UTC](https://forum.dynamobim.com/t/colour-cell-in-excel-using-bumblebee/66766/5 "2021-08-04T05:53:25Z")

</div>

Hi Deniz,

Thank you for your response!  
Nick’s answer worked as I needed it too.  
Thanks again!
