| Home |
| Search |
| Today's Posts |
|
#1
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? There isn't a VBA way to come up with a count for cells highlighted by conditional formatting? DrSues02 -- DrSues02 ------------------------------------------------------------------------ DrSues02's Profile: http://www.excelforum.com/member.php...o&userid=12569 View this thread: http://www.excelforum.com/showthread...hreadid=270702 |
|
#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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count the number of times a cell is colored with conditional formatting
You really don't have to understand Chip's code to use it.
But he wouldn't have written it if there was a built in way to determine the color. -- Regards, Tom Ogilvy "DrSues02" wrote in message ... What if I have logic that is different for several of the cells in the row? There isn't a VBA way to come up with a count for cells highlighted by conditional formatting? DrSues02 -- DrSues02 ------------------------------------------------------------------------ DrSues02's Profile: http://www.excelforum.com/member.php...o&userid=12569 View this thread: http://www.excelforum.com/showthread...hreadid=270702 |
| Reply |
| 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 | |||
![DrSues02[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
