Conditional Format Excel not working (Bumblebee package)

Packages
1

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:

image.png1211×604 90.6 KB

Thanks for your help

2

Hi Zaara,

I’m sorry i have no experience with Bumblebee, but have you seen this picture on this page?
Maybe the above links can help you to solve your problem.

Kind regards,
Mark

3

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

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

image.png749×304 20.1 KB

4

Thanks @Konrad_K_Sobon,
But still not working :s

image.png1613×563 173 KB

5

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

1 Like
6

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

7

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
Conditional Format.JPG1289×425 109 KB

8

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
Cattura.PNG2422×1402 650 KB
Cattura2 Cattura3

9

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!