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

Two categories should be red, two green, and seven yellow. I can do conditional formatting with a rule for each individual entry, but that's incredibly cumbersome.