Excel 2007 formula to count color changes in a cell

A

astrossmart

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

Shane Devenshire

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
 
Top