Staring at Excel spreadsheets for hours on end can really put a strain on Finance staffers’ eyes. The good news is you don’t have to ramp up the font to a cartoonish size to get relief.
What works better: Using a function in Excel that allows workers to shade every other column or row, which makes reading the data much easier on the eyes.
So pass along this step-by-step guide on how to do it to your Finance department:
- Highlight the entire worksheet
- On the Home tab — under the Styles group — click Conditional Formatting and New Rule
- Next, choose Use a formula to determine which cells to format from the top
- Then, enter the formula =MOD(ROW(),2)=0 in the second box
- Click Format and then click the Fill tab
- Pick the color you want to use for the shaded row, and
- Finish by clicking OK twice.