Whenever VBA encounters your given text in the specified column, it will erase the entire row where that text was located. Click the "X" in the top right corner of the editor to close it.

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

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Highlight Cell Rules Using rules to highlight cells based on a value, text, or date is probably the most popular type of conditional formatting in Excel. With this option, you can do things like ...

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

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

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

Conditional Formatting can make a Spreadsheet more relevant Many of us use conditional formatting which changes the colour of a cell where a calculation result sits. This is to easily identify items ...