I have data in a ranges (rows) where the cells in the range contain a formula for forecasting. Users are to overwrite the formula when actual figures are known and I have conditional formatting to highlight the cell. I would like a formula to sum the actual numbers entered for each row and not include the cells with formulas. I tried defining a VBA function to test for cell color but it will not pick up conditional formatting changes.
Any help on this please?