Conditional Formatting in Access and Excel VBA

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition)I have been looking for a way to control the formatting of cells depending on the value of the cell, and the type of product that is listed in a grid.

After looking around I found on MSDN a property called FormatCondition.

Then using that I found the following examples: