How to Make Spesific Excel Rows Bold

Hey @mazlumkacar

What you can do is…

  • Use excel application scope and open the excel file.
  • In that use a read range to read the data so that you can get the number of rows…
  • use a for each row loop and loop through…
  • within the loop, have a variable that increments in each iteration. This variable can be used to identify the row number…
  • have a if condition to check whether the current row has the required value
  • if true, use select range activity and specify the range and highlight that row. You can use the variable we created to specify the range…
  • now use the hot key activity and pass the ctrl + B to change the font style yo bold
3 Likes