| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 - change fill color from one color to another | Excel Discussion (Misc queries) | |||
| Excel 2007 - Pivottable formula with COUNT | Excel Worksheet Functions | |||
| Fixing cell color changes when copying in Excel 2007 | Excel Discussion (Misc queries) | |||
| Cell color pattern styles in Excel 2007 | Excel Discussion (Misc queries) | |||
| using vba to do a count for color cell | Excel Discussion (Misc queries) | |||
Linear Mode
