User Tools

Site Tools


Excel 2016 requires cell background colors and borders to be distinct

The Excel Range Wizard requires that an Excel 2016 spreadsheet have distinct colors for a cell's background and its border.

To remedy this within a spreadsheet:

  • Select target cells
  • Select 'Format Cells'
  • Delete any borders that have the same color as the cell background