Figure F: Copy the format from a single cell to the entire row. Image: Susan Harkins/TechRepublic ACADEMY: Master Microsoft Excel with these 16 courses in this bundled deal.

Open an Excel workbook and select Conditional Formatting > New Rule. Select Format only cells that contain . Select Cell ...

Finally, it’s time to create the conditional format rule that fills alternating groups in the Excel Table: Select the data, B3:F13. (Don’t include the column of consecutive values in column H.) ...

Excel's conditional formatting lets you customize how your data displays, ... Note that all the numbers in column C that are above average are now displayed in bold red.

If you have product numbers that start with one or more zeros, Excel will knock off the leading zeros from your product numbers. So, 00123 will be displayed as 123. The solution is to use a custom ...

To show numbers in thousands or millions in Excel, you can use these two formatting conditions: #0,”K” and #0,,”M”. To apply them, select the cell, right-click on it, and select the Format ...

Open the Excel 2010 file that contains the phone numbers you want to change. Click on the cell that contains the phone number, or click on the range of cells if you want to change the format for ...

If you change the format of empty cells, any numbers you type in those cells are converted to percentages automatically. Launch Excel and open the workbook that contains the spreadsheet you want ...