Syntax

expression.Interior

expression A variable that represents a CellFormat object.

Example

This example sets the search criteria to identify cells that contain a solid yellow interior, creates a cell with this condition, finds this cell, and notifies the user.

Visual Basic for Applications 
Sub SearchCellFormat() ' Set the search criteria for the interior of the cell format. With Application.FindFormat.Interior .ColorIndex = 6 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With ' Create a yellow interior for cell A5. Range("A5").Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Range("A1").Select MsgBox "Cell A5 has a yellow interior." ' Find the cells based on the search criteria. Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _, SearchFormat:=True).Activate MsgBox "Microsoft Excel has found this cell matching the search criteria." End Sub

See also: