In the formula box, enter =ISBLANK(active cell reference). Click Use a formula to determine which cells to format.Select the range of cells in the column where some of the cells contain blanks.To highlight the blanks using conditional formatting: In the example below, there are blanks in column C: You can use conditional formatting to highlight blanks in a range of cells. Highlighting blanks using conditional formatting Click the Fill tab and select a light fill.
Excel uses relative referencing by default so the formula will be copied down and adjusted for the remaining cells. Enter the formula for the first cell in the range. In the formula box, enter =ISERROR(active cell reference). Select New Rule from the drop-down menu.Click the Home tab in the Ribbon and select Conditional Formatting in the Styles group.Select the range of cells in a column where some of the cells contain errors.To highlight the errors using conditional formatting: In example below, there are errors in column C: You can use conditional formatting to highlight errors in a range of cells. Recommended article: 15 Microsoft Excel Keyboard Shortcuts to Speed Up Formattingĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Highlighting errors using conditional formatting Below is a sample of a rule with a formula: You can apply conditional formatting using a formula and a new rule. In this article, we'll use some simple examples to show the power of conditional formatting.Ĭonditional Formatting appears on the Home tab in the Ribbon in the Styles group. Use Conditional Formatting in Excel with Formulas to Highlight Errors, Blanks and Duplicatesīy Avantix Learning Team | Updated April 7, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)Ĭonditional formatting is a great tool in Excel and if you combine it with formulas, you can do some amazing things.
0 kommentar(er)
