Is there a way to count the number of cells that have been coloured in by autoformatting?
P Peter Oct 16, 2004 #1 Is there a way to count the number of cells that have been coloured in by autoformatting?
D Dave Peterson Oct 17, 2004 #4 I think it's a lot easier to use other cells that contain the same formulas as the conditional formulas and check then check them. But Chip Pearson has some code at: http://www.cpearson.com/excel/CFColors.htm That may help you.
I think it's a lot easier to use other cells that contain the same formulas as the conditional formulas and check then check them. But Chip Pearson has some code at: http://www.cpearson.com/excel/CFColors.htm That may help you.
