UiPath Excel Conditional Formatting

Help Studio
, ,
1

Hi,

Hope everyone is well.

I am new to UiPath and I would like to seek some help on how to do conditional formatting on the output.

Everything is calculated (download, extraction, generate and calculation).

The output file name is Report.

As a new user, unfortunately, I cannot upload the sample.

image

Processing: DNX.zip…

Any help is appreciated.

2

Hi @catsummer88

I cant get your error clearly
could you please attach some screenshots so that we will understand your issue

Thanks,

3

Hi @Robinnavinraj_S,

I didn’t have any error with the file.

I’m seeking help on how to implement conditional formatting of the output.

The remaining hours calculation:
Month total - Time allocation.

So of remaining hours (column E) is < 1

The cell will turn it green and so on as per the number range above.

4

DNX.zip (9.9 KB)

Adding sample workflow.

Thank you

5

Hi @catsummer88

PFA xaml file & try out this

Thanks,
DNX.zip (18.6 KB)

6

Hi @catsummer88

Kindly let me whether you have got the solution or not with the xaml file which i have provided .
if yes , mark it as solution which would be helpful to others for reference or else if you are got stuck please reply

Thanks,

7

Hi @Robinnavinraj_S,

I will test the xaml file you have provided tomorrow and will let you know.

Thanks for all your help

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.