Range.DisplayFormat (Excel)

Returns a DisplayFormat object that represents the display settings for the specified range.

DisplayFormat is affected by conditional formatting as shown in the code below. It adds conditional formatting to Cell A1 on the ActiveSheet. This formatting bolds the cell, changes the interior color to red and adds a checker pattern.

Dim dftDisplayFormat As DisplayFormat
Set dftDisplayFormat = ActiveCell.DisplayFormat