Forum Discussion
Define Gridlines Based on Bin Values from Sort
Let's say the days of the week are in D2:D100.
Select this range. D2 should be the active cell in the selection.
You can also select multiple columns, e.g. A2:K100.
The active cell should still be in row 2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'not equal to' from the second drop down.
In the box next to it, enter the formula =$D1
(D1 is the cell in the day column above the row with the active cell)
Click Format...
Activate the Border tab of the Format Cells dialog.
Click on the top border of the example box.
You can select a color for the border if you wish, before clicking the top border in the example box.
Click OK, then click OK again.