Forum Discussion
how to add colors without using the template for tables
I am new to this and am doing my best to learn daily. I am making a chart that lists where I spend money on bills and how much. i am attempting to put the colors on the sheet where one line is blue a...
Sounds like you're at the stage where your new 'best friend' could be the 'undo' button ('ctrl+z', if you want a shortcut)! You might also consider keeping a backup copy of your workbook if you think you may perpetrate a disaster.
It is possible to shade alternate rows by using Conditional Formatting with a formula
=ISEVEN(ROW(A1))
but I do not recommend it. Use a Table and choose a style to suite your taste*. That will place you one step ahead of the basic spreadsheet user when it comes to having usable data.
* I always use Table Design on the Ribbon to select the light grey style and then I remove filters and banded rows but that would defeat your objective.
PeterBartholomew1 Thank you so much, I will give that a shot!