Workflow error: Using if to find Percentages


I currently have a workflow, that looks something like this; Main.xaml (10.1 KB) to highlight all percentage values that do not equal 7% or 0%. However, when I run the process, all my cells are getting highlighted and I am not able to figure out the problem. Sample of workbook attached. Book1.xlsx (13.6 KB)

Any help would be greatly appreciated! Thank you!

Best Regards!

Updated your workflow Main.xaml (11.4 KB)
Index should be "E"+(index+2).ToString
and you should check if the cell is numeric first

Thank you so much! It works brilliantly!

Best Regards

1 Like

no problem! good luck

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