Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Detecting a color
Is there a way I can detect if any cell is a certain color in a range of cells?
|
#2
|
|||
|
|||
Hi
see: http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Frank Kabel Frankfurt, Germany "Duncan Help" schrieb im Newsbeitrag ... Is there a way I can detect if any cell is a certain color in a range of cells? |
#3
|
|||
|
|||
Duncan
It depends what you want to do, there have been a few questions already regarding counting or summing the contents of coloured cells and there are some links. If you type colored cells into the search on this discussion forum, you might find what you want. "Duncan Help" wrote: Is there a way I can detect if any cell is a certain color in a range of cells? |
#4
|
|||
|
|||
I took a look and I see how to count in VB, but more specifically what I am
looking for is a formula to return a TRUE or FALSE if there is a certain color in a range, color RED. "LizJ" wrote: Duncan It depends what you want to do, there have been a few questions already regarding counting or summing the contents of coloured cells and there are some links. If you type colored cells into the search on this discussion forum, you might find what you want. "Duncan Help" wrote: Is there a way I can detect if any cell is a certain color in a range of cells? |
#5
|
|||
|
|||
Can I do this as a function in Excel, I believe the link shows ways to do it
in VB. Basically I have a range of cells, and I want to TRUE or FALSE answer as to whether any of them are RED. "Frank Kabel" wrote: Hi see: http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Frank Kabel Frankfurt, Germany "Duncan Help" schrieb im Newsbeitrag ... Is there a way I can detect if any cell is a certain color in a range of cells? |
#6
|
|||
|
|||
Hi
you need VBA. There's no worksheet formula for this -- Regards Frank Kabel Frankfurt, Germany "Duncan Help" schrieb im Newsbeitrag ... Can I do this as a function in Excel, I believe the link shows ways to do it in VB. Basically I have a range of cells, and I want to TRUE or FALSE answer as to whether any of them are RED. "Frank Kabel" wrote: Hi see: http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards Frank Kabel Frankfurt, Germany "Duncan Help" schrieb im Newsbeitrag ... Is there a way I can detect if any cell is a certain color in a range of cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
font color | Excel Discussion (Misc queries) | |||
Changing color in color palette | Setting up and Configuration of Excel | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |