def thick_border_white_cell_style(cell):

        cell.font = Font(name='Verdana',
                         size=8,
                         bold=True,
                         color=DesignUtils.color_palette()['BLUE6'])
        cell.border = Border(
            left=Side(border_style='thick',
                      color=DesignUtils.color_palette()['BLUE6']),
            right=Side(border_style='thick',
                       color=DesignUtils.color_palette()['BLUE6']),
            top=Side(border_style='thick',
                     color=DesignUtils.color_palette()['BLUE6']),
            bottom=Side(border_style='thick',
                        color=DesignUtils.color_palette()['BLUE6']))
        cell.alignment = Alignment(horizontal='center', vertical='center')

        return cell
    def header_style_light_blue(cell):

        cell.font = Font(name='Verdana', size=8, bold=True, color=colors.WHITE)
        cell.border = Border(left=Side(border_style='thin',
                                       color=colors.WHITE),
                             right=Side(border_style='thin',
                                        color=colors.WHITE),
                             top=Side(border_style='thin', color=colors.WHITE),
                             bottom=Side(border_style='thin',
                                         color=colors.WHITE))
        cell.fill = PatternFill(patternType='solid',
                                fgColor=DesignUtils.color_palette()['BLUE2'])
        cell.alignment = Alignment(horizontal='center',
                                   vertical='center',
                                   wrap_text=True)
        return cell
    def thick_border_fill_cell_style(cell):

        cell.font = Font(name='Verdana',
                         size=8,
                         bold=True,
                         color=DesignUtils.color_palette()['BLUE6'])
        cell.border = Border(
            left=Side(border_style='thick',
                      color=DesignUtils.color_palette()['BLUE6']),
            right=Side(border_style='thick',
                       color=DesignUtils.color_palette()['BLUE6']),
            top=Side(border_style='thick',
                     color=DesignUtils.color_palette()['BLUE6']),
            bottom=Side(border_style='thick',
                        color=DesignUtils.color_palette()['BLUE6']))
        cell.fill = PatternFill(
            patternType='solid',
            fgColor=DesignUtils.color_palette()['LIGHTBERLINBLUE'])
        cell.alignment = Alignment(horizontal='center', vertical='center')

        return cell