This is a quick guide to add structure and ease of reading to any spreadsheet that you might be struggling to decipher.
Have you ever made or received a spreadsheet and you shuddered at the lack of clarity and wondered how can I make this look cleaner and easier to read? Fear not as I have come across a nice trick to help you add clarity by applying colors to alternate rows in your spreadsheets. Here's how:
Select the range of cells that you want to format.
Click Home and go to Conditional Formatting.
Select new rule
Choose Use a formula to determine which cells to format.
Enter the following formula into the appropriate area: =MOD(Row(),2)=1, then click format
Click the Fill tab and select a color, the select ok
Click OK once more to apply the formatting.
Once you have done this you will be presented with an easy to read spreadsheet.