Chaitanya_Raju
Honored Contributor

Hi @Mohammed sadamusean​ ,

Can you please try similar to below code using loops, I have implemented a similar use case that might be useful, please let me know if you need further

 top = Side(border_style = 'thin',color = '00000000')
 bottom = Side(border_style = 'thin',color = '00000000')
 left = Side(border_style = 'thin',color = '00000000')
right = Side(border_style = 'thin',color = '00000000')
border = Border(top = top,bottom = bottom,left = left,right = right)
 
for cell in sheet['C18:C56']:
      cell[0].fill = PatternFill("solid", start_color="00C0C0C0")
       cell[0].border = border

Happy Learning!!

Thanks for reading and like if this is useful and for improvements or feedback please comment.

View solution in original post