| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AUTO SUM ONLY SPECIFIC COLORED CELLS BY CONDITIONAL FORMATING
Conditional formatting does not change the .interior.colorindex property of a cell. You need to look at the formula(e) which determines whether to colour the cell red (usually colorindex of 3) and use that with sumif or the like. What formula determines a .colorindex of 3 in CF? -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=157094 Microsoft Office Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Colored Cells that are Conditional Formated | Excel Discussion (Misc queries) | |||
| Conditional Formating and auto filling | Excel Discussion (Misc queries) | |||
| Conditional Formatted Colored Cells | Excel Programming | |||
| CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS | Excel Worksheet Functions | |||
| conditional formating a specific amount of cells in a row. | New Users to Excel | |||
![p45cal[_194_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
