Sum of two columns cell values in excel and output need to be stored from input dialog box

Hi,

Sum of two columns cell values in excel and output need to be stored from input dialog box by user.
If we are writing the wrong sum value in cell and that need to be highlighted in specific cell.

Regards,
Lakshmi

do you have excel example?

and what do you mean by wrong sum value?

image
col A and col B will be having values and col C is the sum value given from input dialog box.
Example: 500+5000=5500 , in excel given as 6000 and that cell has to be highlighted. If the sum value is wrong that particular cell needs to be highlighted.

Seq excel add.xaml (12.0 KB)
colA colB.xlsx (8.8 KB)

Regards,
Lakshmi

1 Like

Hi @lakshmi.mp ,

Check the Below Updated Workflow :
Seq excel add.xaml (10.4 KB)

I have made it to work Dynamically. Also for Coloring the Cells we would require to use the Excel Activities and not the Workbook.

So I have changed from Workbook to Excel Activities.

Let us know if it doesn’t work.

Hi @supermanPunch ,

Thank you for helping, its working.

Thanks & Regards,
Lakshmi

1 Like

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