뉴스

Automatically format data in your spreadsheet to make it easy to spot. Set up conditional formatting in Excel in just minutes.
Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.
Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.
Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart.
You can use conditional formatting to format Completed tasks in green, In Progress ones in yellow, Blocked tasks in red, and Not started to-dos in light gray.
Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.
If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.