I am looking for a way in VBA to do the following:
Go through the current worksheet and if the formula references a cell, ON THE SAME WORKSHEET, that is after the current row (i.e. at least one row below), then that cell should be shaded grey. So, for example, if I have the formula on sheet1! in cell C10: = B11+4, then this cell should be shaded grey (as it referes to a cell on the same worksheet below the current row). If I have the formula in cell C10: = Sheet2!B11+4, then there should be no change to the cell(as it refers to a cell on aother worksheet. If I have the formula in cel C10: =X10 +4, then nothing should change (as it refers to a cell on the same row).
There should be a way to do this easily in VBA.
Thanks so much.
Go through the current worksheet and if the formula references a cell, ON THE SAME WORKSHEET, that is after the current row (i.e. at least one row below), then that cell should be shaded grey. So, for example, if I have the formula on sheet1! in cell C10: = B11+4, then this cell should be shaded grey (as it referes to a cell on the same worksheet below the current row). If I have the formula in cell C10: = Sheet2!B11+4, then there should be no change to the cell(as it refers to a cell on aother worksheet. If I have the formula in cel C10: =X10 +4, then nothing should change (as it refers to a cell on the same row).
There should be a way to do this easily in VBA.
Thanks so much.
