Problem Excel conditional formatting

Help StudioX
, , ,
1

Hello, I would like to formatting an Excel Cell if there is a certain value.
It should be like a conditional formatting in Excel.

I already get it for one cell, but as soon as I would like to repeat it for each cell it doesn’t work.

How can I solve it?

2

Hi @melanie.schlenk,
Please try to give more information about the error. Include images, descriptions, paste the code that is failing.

Cheers!

3

I have this Else If function and I would like to repeat it for the complete column

image
image404×721 20 KB

I only got it for the first cell I’m using it.

4

Hi @melanie.schlenk,
Try this as follow:

  1. Try to use a For Each Excel Row
  2. Inside of the previous activity you need to include your Else-If activity.

image
image771×1469 40.6 KB

Hope it helps you!

5

I’m sorry but it doesn’t work…

Is there something else I can try?
I’m using Studio X, maybe this is the problem?

6

Hi @melanie.schlenk,
Attached here you can find a demo project in Studio X.
NewBlankTask.zip (56.7 KB)
Hope it helps you!