| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the number of times a cell is colored with conditional formatting
What if I have logic that is different for several of the cells in the
row? You have to count the cells colored via each of your logical expressions and add the totals together. There isn't a VBA way to come up with a count for cells highlighted by conditional formatting? No, there isn't. There's a cell property that returns the interior color, but it returns the color the cell would have if there were no conditional formatting. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of times a cell in a column is shaded green | Excel Discussion (Misc queries) | |||
| Count the number of times a cell value is within a specific range | Excel Worksheet Functions | |||
| How do I count the number of times a letter is used in a cell? | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Count the number of times a cell is colored with conditional formatting | Excel Programming | |||
Threaded Mode
