Hi,

I have an Excel document with a lot of formulas and so on, intermittently, the cells when i scroll down for instance some cells are blank, not all, just a random few. They have either formulas in or an actual value, when i select them i can see the contents in the formula bar at the top but not in the cell. If I highlight a number of cells, not just a single cell, it then shows what it is supposed to show. Then later on it will happen to another bunch of cells. The only consistency is that the value or the sum of the formula equals zero in every cell it happens to, it does not happen to a cell with a number above zero in.

Hi,

Since you want to highlight blank cells, you can apply conditional formatting > Highlight Cells Rules.

For more reference about Conditional Formatting:

http://office.microsoft.com/en-001/excel-help/quick-start-apply-conditional-formatting-HA010370614.aspx

http://office.microsoft.com/en-001/excel-help/use-a-formula-to-apply-conditional-formatting-HA102809768.aspx

Regards,

Greta Ge
TechNet Community Support