ExcelBanter - Excel 2007 formula to count color changes in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2007 formula to count color changes in a cell (https://www.excelbanter.com/excel-worksheet-functions/212209-excel-2007-formula-count-color-changes-cell.html)

astrossmart

Excel 2007 formula to count color changes in a cell

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

Shane Devenshire[_2_]

Excel 2007 formula to count color changes in a cell

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?

All times are GMT +1. The time now is 01:35 AM.