This post will guide you how to highlight all precedent or dependent cells in excel. How do I find out all precedent or dependent cells then highlight those cells in excel. You can use the Go to Special function to find the precedents or dependents cells and then fill color for those cells.
Highlight all Precedents or Dependents
To highlight all precedents or dependents, you just need to do the following steps:
#1 Select the range of cells that you want to find precedent or dependent cells.
#2 go to HOME tab, click Find&Select command and then select the Go To Special from the drop-down list. The Go To Special dialog will appear.
#3 choose Precedents radio button to find all Precedents, or select Dependents radio button to find all dependent cells. And click OK button.
#4 All precedent cells or dependent cells will be selected. Go to Home tab, click Fill Color to set one color as you need to highlight those selected cells.