To format cells based on their contents, trap the CellChanged event and apply the formatting using the Cell property. For example, you can make negative values red and bold or give values above a certain threshold a blue background.