How to bold a row with a condition that contains sub total on a sheet

Hello Guys, how can i bold a specific row that contains(“Sub Total”).

For your reference

As you can see on the photo there is multiple Sub Total, I’ve tried the Find in Excel but it always goes back to the first sub total…

Thank you so much.

You can loop through your file to find the cell ID of all cells matching the text “SUB TOTAL”, and then use “Format Cells” on the cells you’ve found.
The Find activity will only return one match I think, so I don’t believe it fits your needs.

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