Hi,

There is no formula in Excel to do this. I'm not sure you could even write
a function for this because the Worksheet_Change event doesn't respond to
format changes.

If this helps, please click the Yes button

cheers,
Shane Devenshire

"astrossmart" wrote:

Is there an EXCEL 2007 formula that counts the number of times a cell
(example "A1" only) changes color?