Hi @Nithinkrishna @ermanoj3101
Excel.xlsx (11.6 KB)
Testing Analysis.zip (10.7 KB)
PFA excel sheet as u can see in “Part Number”(Column V) values are same in v2 & v3
But in “Description”(Column W) value are different.
I just want that whenever “Part Number” are same but having different " Description"
then it should be highlighted like this:-
If possible please append this logic on the attached code.
@Nithinkrishna pls help on this case…!!!
Understood your issue. Coloring the cells in a direct way looks unfamiliar.
We may need to check the possibilities with macro.
But do you really want it to color or any other output format you prefer.
just it’s need to be highlighted
Colouring is prefered
Okay let me see what can be done.
This will take a bit time to build just bear with me please.
just for reference u can try this activity:-
@Nithinkrishna is it done…?
@Nithinkrishna bro are we close…?
@Nithinkrishna pls HELP…!!
@mitul_choudhary will there be multiple matching rows as well ?
I mean different part numbers in the sheet or every sheet will have only one unique part number ?
It has only one sheet in excel in which there will be same part number but different desciption
Like this bot has to identify & highlight those.
Hope it helps
@Nithinkrishna remember same part number & different description can be in different
row too like this, therefore bot has to identify where it is
Logic is almost done.
But can i get another sheet like the above with multiple po numbers
Not yet @mitul_choudhary Just give me some time pls
If let’s say we have two records with different descriptions then both should be highlighted ? or only the wrong one ?
Could you please clarify this ? @mitul_choudhary
Please try below code and let me know
The code will highlight the same partnumbers with same description and different description, and you can highlight to the color of your choice
Let me know if you need any changes
Coloring.xaml (26.0 KB)
Thanks and Regards.
@vinithareddyk123 it should only highlight same part number with different description.
@vinithareddyk123 pls look
Report is ready, Could you please review and confirm…
New_Custom_Copy_Output-071421041554.xlsx (626.4 KB)
Attaching the code as well -
ExcelColoringForDataMismatch.zip (501.9 KB)
Thanks for bearing the time.