| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula using color of a cell
Is it possible to write a formula which looks up a range of cells fo certain color and sum the cell with certain color. So, something of the form =sumif(B8:B20=certain color condition,B8:B20,0) can colorindex property of cell be used somehow?? Thanks in advance. Ja -- sa0200 ----------------------------------------------------------------------- sa02000's Profile: http://www.excelforum.com/member.php...fo&userid=2774 View this thread: http://www.excelforum.com/showthread.php?threadid=55554 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to set cell color | Excel Discussion (Misc queries) | |||
| Formula to set color in a cell | Excel Worksheet Functions | |||
| Cell color formula | Excel Discussion (Misc queries) | |||
| color a cell with a formula in it? | Excel Worksheet Functions | |||
| need formula to add cell sums by color of cell | Excel Discussion (Misc queries) | |||
![sa02000[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
