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

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

Learn how to fix Excel conditional formatting issues with dynamic references, OFFSET function, and defined name method for clean spreadsheets ...

Excel offers many different tools for formatting your charts, but the key to success is choosing which ones to use. In this guide, I'll share some of my favorite chart-formatting hints, hopefully ...

Improve the appearance and usability of your Excel worksheets with these simple format options.

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

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.

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.

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

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.