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.
PeterBartholomew1 Thank you so much, I will give that a shot!
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.
