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.
Yahoo

Pro tip: Use Excel's conditional formatting to highlight invalid dates

Last month, we used conditional formatting to highlight holidays in a matrix-style calendar; we added this enhancement to an earlier article that used conditional formatting to highlight weekends. By ...