Forum Discussion
Please Help: How to find all cells those value are resulted from other cells
Hello, I have a workbook that contain both numeric number in constant and formula. My problem is I want to find all the cells those value are resulted from other cells. Please see the below exam...
Highlight all of the cells you want to check. Select Conditional Formatting on the Home tab.
Select New Rule... then select Use Formula to determine...
In the box put =isformula(b3) Make sure B3 is the upper left corner cell of the ones you are wanting to check. If it is not, place that cell reference in there. Only put in the upper left cell, without any $. Then select the Format button, select the Fill tab, and select a highlight color. Say ok until you are out. all of the cells with formulas should now be highlighted the color you chose.