Forum Discussion
how to add colors without using the template for tables
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.
IMHO, there is no suitable style with banded rows and columns plus alternate rows. Thus options are to create own style, or =MOD(ROW(),2) on the top of the existing style. The latest is the common practice, in particular it is used in Microsoft templates.
SergeiBaklan Thank you for this, I LITERALLY just saw a guy do this on YouTube per someone elses advice. i appreciate your assistance
In that case I probably misread the OP initial requirement. I read it as how to get the appearance of a table without actually using a table (I guess I needed a picture). Mind you, from my postscript it might be that I am not the best person to consult on Table and PT styles, since I tend to standardise on black ink on white paper (though I do remember when green text on a black background was all that could be achieved).
Sorry, my comment was only to your post, not to initial requirements, didn't check them in details.
