Can Excel Conditional Formatting Change Border Line Thickness?
Question details
The user is inquiring whether it is possible to apply thicker border lines using conditional formatting rules in Microsoft Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Setting up conditional formatting rules to highlight specific cells by changing their border thickness.
- Observed behavior
- Excel limits conditional formatting to standard border thickness, and the heavier border options available in normal cell formatting are excluded from the rules.
Before attempting complex workarounds, verify if using distinct background fill colors or bold text can serve as an effective alternative to thick borders for highlighting your data.
Use Alternative Visual Formatting Indicators
Since thick borders are not supported, utilize other conditional formatting options such as fill colors, font styles, or icon sets to effectively highlight your data.
Excel's conditional formatting engine restricts border options by design. The most reliable way to highlight cells dynamically is to shift away from border thickness and use color-based indicators instead.
Select the range of cells you want to monitor. Go to the 'Home' tab on the Excel ribbon and click on 'Conditional Formatting'.
Choose 'New Rule' from the dropdown menu, or select an existing highlight rule that matches your data criteria.
Click the 'Format...' button to open the Format Cells dialog. Instead of the Border tab, navigate to the 'Fill' tab to choose a prominent background color, or use the 'Font' tab to apply a bold style or contrasting text color.

Automate Custom Borders with VBA
If a thick border is strictly required for your document's layout, you can bypass formatting limits using a VBA macro.
Submit a Feature Request to Microsoft
Let the Microsoft development team know that thick border formatting is a necessary feature for your workflow.
Try WPS Office for Seamless Spreadsheet Management
While advanced conditional border formatting is limited in standard spreadsheet software, WPS Office serves as a highly compatible, free, and lightweight alternative to Microsoft Office. It handles all your daily spreadsheet tasks with ease.
- 1. Download WPS Office: Visit the official WPS website and download the free office suite installer for your operating system.
- 2. Install the Software: Run the setup file and complete the fast, lightweight installation process.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and easily open your existing Excel documents to resume working.

Frequently Asked Questions
Why are thick border options missing in Excel conditional formatting?
This is a known design limitation in Microsoft Excel. The conditional formatting engine only supports a restricted set of formatting properties. It excludes heavier border styles to simplify rendering rules and maintain application performance across large datasets.
Can I use icon sets instead of changing border thickness?
Yes. Icon sets are an excellent built-in alternative for conditional formatting. They allow you to place small visual indicators (like arrows, traffic lights, or flags) inside the cell based on its value, providing a clear visual cue without needing to modify cell borders.
Can I manually add a thick border instead?
Yes, you can apply a thick border manually by selecting your cells, pressing Ctrl+1 to open 'Format Cells', and adjusting the border settings. However, this border will be static and will not change dynamically based on the cell values like conditional formatting does.




