Workflow error: Using if to find Percentages

[h2000]

Hi!

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!

[jack.chan]

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

[h2000]

@jack.chan

“E”+(index+2).ToString

Thank you so much! It works brilliantly!

Best Regards

[jack.chan]

no problem! good luck