Forum Discussion
Highlighting alternate rows using conditional formatting
Hi all, I am constructing a simple personal budget (Income, expense) excel sheet, and listing my expenses on a daily basis. I am hoping to highlight the rows based on alternate days for easy refe...
Why not convert the data into an Excel Table and you will have the desired layout without any conditional formatting?
Select one cell in your data and press Ctrl+T and in the new popped up Create Table confirmation window, check the CheckBox next to "My table has headers" and click OK to finish.
Once your data is converted into an Excel Table and any cell is still selected in the Table, you will find a new tab called "Table Design" and there you can change the different Table Style if you don't like the default style.
Table Design Tab will only appear on the Ribbon if you select any cell in the table.