To extend your conditional formatting to a new part of the spreadsheet, a new worksheet or even a new workbook, Excel's "Format Painter" feature lets you easily copy conditional formatting.

Let’s talk about formatting shortcuts in Excel. Say you need to format several areas quickly. These six Excel hacks show how to do the job in a tenth of the time it would usually take. Shaun ...

Use conditional formatting If you want to make your task list more dynamic, you can use formatting where the system formats your cell based on specific values and text.

As an example, suppose you have an Excel workbook that contains each student’s numerical course grades, but you would like a visual way to differentiate each student’s letter grade (A, B, C, D, or F).

You can use conditional formatting to display simple graphs at the cell level. Susan Sales Harkins explains how.