Conditional Formatting Based On Another Cell Excel VBA Macro

Conditional formatting is a feature of Microsoft Excel that allows highlighting certain values to easily identify those cells. Excel offers various options for numerical values (greater or less than, between, top 10, data bars, color scales, icons, etc.), but there are less options for text. In both cases, we can set rules manually to apply formatting based on a given condition. This video shows how to apply conditional formatting rules automatically using Excel VBA macros. The macro specifically applies formatting to a column based on the value in another cell. A slight variation of the code allows to highlight the entire row in the table.

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga: