Hi everyone, What I want is to be able to click on a cell that has a countif formula, and then it be able to highlight all cells that contribute to the countif answer. I want it to be an automatic macro so that when I click on the cell with the formula, all the cells that apply to the countif...