ConditionalFormats object
The conditional formatting feature allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. The ConditionalFormats collection holds a collection of ConditionalFormat objects. Use the ConditionalFormats property to access the control's ConditionalFormats collection .The ConditionalFormats collection supports the following properties and methods:

  AddAdds a new expression to the collection and returns a reference to the newly created object. 
  ClearRemoves all expressions in a collection. 
  CountReturns the number of objects in a collection. 
  ItemReturns a specific expression. 
  RemoveRemoves a specific member from the collection.