Hi All, Please help
I have excel file with below columns in this i need to apply conditional formatting >> Duplicate values to MOVER ID and OGConfirmation… and if any values in OGConfirmation column with 4657-XXX-X-XXX are high lighted as show below need to update Manual column row as Dupe for that row item.
@Parvathy Thank you for the response. the input file in this
i need to do the above mentioned steps.
@ManjuNarasappa do you need the excel file to display the red conditional formatting or do you only care about the Manual column being updated to Dupe? This will help in understanding if a macro needs to be created.
@logan_anderson Thank you for response.. I want to update Manual column as Dupe that is important based on OGConfirmation duplicate row item 4657-xx-xx
.
@ManjuNarasappa I’ve gone ahead and written a Dupe filter via code rather then using Conditional Formatting inside excel. Let me know if this is what you are looking for or if you want this to be solely inside excel!
ExcelDupe.zip (124.7 KB)
Thank you so much… this is helping to update the Manual column as dupe if OGConfirmation column having 4657 value, but I need to check whether any duplicates between MOVER ID and OGConfirmation column in that if OGConfirmation column contains 4657 rows item then update Manual column as Dupe.
@ManjuNarasappa thanks for the information! Are you saying that a row is considered a Dupe if:
- MOVER ID is considered a Duplicate
- OGConfirmation is considered a Duplicate
- OGConfirmation starts with 4657
An example that would not get marked as a Dupe would be:
MOVER ID | OGConfirmation Test | 4657-1234-1-3456
You can record the macro and use it to format and update the values.
After applying conditional formatting >> Duplicate values as shown below, The line items in OGConfirmation column in pink colour with row 4657-x-xxx need to update as DUpe in Manual column.So here two rows contains 4657 data so for these two row items need to update as Dupe Manual column.
Hi @ManjuNarasappa
You can use macro for conditional formatting. It is very suitable for this kind of excel operation.
The script would be similar to give below.
get the macro, save it as module in excel and test it before using it in automation.
