(from Chandoo.org via Lifehacker)
Impress your colleagues – and your boss! – with these very cool Excel tricks:
1) Highlighting alternative rows / columns in tables
2) No-nonsense project plans / gantt charts
3) Extreme in-cell graphs
4) Highlight mistakes, errors, omissions, repetitions
5) Create intuitive dashboards
Detailed, easy to follow instructions and a downloadable spreadsheet with examples available at Chandoo.org:
Want to be an Excel Conditional Formatting Rock Star? Read this
Chandoo.org
March 13, 2008