Hello, I am relatively new to Uipath. I am trying to format an excel sheet by adding a conditional formatting rule that finds duplicates like in the image below
I have a sheet where I have separated the negative rows from the positive based on column D. Now I am trying to match the bottom positive end of the table with the top negative based on the value in column C, highlighting the found duplicates. Is there a way for me to do this using uipath?
hi @William_Blech_Sister, thank you for your response.
Yes please,an explanation would be greatly appreciated. And also, will i be able to use this method if my table rows and columns are dynamic.