Susan Harkins shows you how to format and unlock input cells in Excel at the same time by assigning a modified style.

The first step in making a spreadsheet readable is to tidy up the cell formatting. By smartly using cell borders, shading, ...

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.

Do you want to format an object or text with the same formatting as the previous one but want to save time than formatting the new object? You can use Format Painter in Word, PowerPoint, and Excel.

Changing the color of a range of cells affects a cell that is not in the range. This one is really weird and kind of unexplainable. Formatting a set of cells to one color affects a cell that is out ...

You can type codes in VBA Editor to change the cell colors in Excel. Learn how to change the cell background color with VBA Editor in Excel.

Microsoft Excel 2007's conditional formatting feature allows you to format cells based on certain criteria. As an example, you might want the row color to change based upon a credit or debit on a ...

Spread the loveMicrosoft Excel is an extremely powerful and versatile tool that can help you make sense of large amounts of data. One of the key features of Excel is its ability to format cells, ...

How to Use If-Then Excel Equations to Color Cells. If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others ...