Conditional Formatting

Copper Contributor

I wrote a formula for a cell in a column, then copy paste the same formula in whole column means all cells under the upper cell, by mistake in the middle of column , I changed the formula. I forgot my mistake, the value of that mistaken cell had changed , and calculations result went wrong, I want such conditional formatting that that particular mistaken cell should automatic change it's color, and alarm me that in the whole column that cell has different formula from the other cells of column ??

1 Reply


Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.