How to color if values is available and write match in other column

Help Studio
, ,
1

how to color if values from column F (which as No Headers) matches with column B and write match in column D

image

2

you can create a condition and then use the following activity

Also if you do not wish to use excel application scope then you can create a VBA code and run that as a script.

3

Hi rahul,

Thank you for your reply,

I am new to uipath can u pls tell me what to write in IF condition because both column B and F values will be changing every time when this file is created.

1 Like
4

Sure!

Made a quick workflow, this will help you to understand. Happy automating!

ColorCell.zip (9.3 KB)

5

Thank you Rahul for your quick response

Can u pls correct me where i did mistake color was not highlighting in Excel

BOM_Comparision.zip (1.0 MB)

6

I couldn’t find a case that fits your initial question. Can you just send a sample of the excel with the part of the workbook that you are working with instead of the full workflow?

Best,
Charbel

7

Hi Charbel,
pls check this one

BOM_Comparision.zip (634.8 KB)

Actually, I can able to write the not available values in the “Q3” cell by comparing material columns “B” & “J” but I want instead of writing in other cells. I want just to highlight the values which are not available in the column “J” compare to column “B”

8

Hi Charbel,

I hope I have cleared your doubt, if not please let me know…

9

I’m checking the workflow👍

1 Like
10

Okay, I think I understood what you mean.

Is this the result that you want:
Book1.xlsx (24.0 KB)

11

Here are the updates that I made:

image
image793Ă—658 16.2 KB

image
image675Ă—679 15.1 KB

  1. Copied the same Read Range that you previously used for DT2. (The Read Range of the J column)
  2. In For Each Row, I changed dtoutput to result_Notmatched
  3. Changed value in assign activity to intff+2

Best,
Charbel

12

Hi Charbel,
yes…
Let me try from my side and can you pls attach xaml file if possible
and is it possible to write as “NEW” in column P as below

image
image1151Ă—547 34.7 KB

13

BOM_Comparision.zip (623.1 KB)
I changed some stuff in the paths, so just copy the part that I updated.

For the “NEW” part, you can use this Write Cell activity:

image
image647Ă—777 17.1 KB

The cell value is:

"P" + intcellv.ToString
1 Like
14

Hi Charbel,

Fantastic…

Thank you so so much

It works perfectly …

15

You’re more than welcome!

Feel free to tag me in case you have any additional questions.

1 Like
16

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