Excel automatically copies the formatting into the range when you release the mouse button. To copy conditional formats multiple times, double-click Format Painter.

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

Learn how to master Excel 365 conditional formatting to transform raw data into actionable insights with this step-by-step guide.

Pro Tip: To open formatting options, just select the cell (s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc.

Avoid frustration and unintended formatting by learning how Excel applies conditional formatting rules.

Formatting using color is such a basic function of Excel that if, after all of the above, you still find that the color options aren’t working, I can only conclude that there must be something ...

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight ...