You don't have to do it manually.
How-To Geek on MSN
Manual color-coding is breaking your Excel spreadsheets—here's the fix
Stop painting cells and use conditional formatting to build accessible, formula-ready, and automated Excel spreadsheets.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results