Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cells based on conditional formatting
hello -
I've conditionally formatted a column of cells to a yellow background based on the sum of 5 other cells in the row. Now I want to count the number of yellow cells. I don't know VB, so if someone knows a formula method to count the cells, that would be great. Thanks, Marc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cells based on conditional formatting
Hi Marc,
http://www.cpearson.com/excel/CFColors.htm use the Chip Person tips. hth regards from Brazil Marcelo "Marc" escreveu: hello - I've conditionally formatted a column of cells to a yellow background based on the sum of 5 other cells in the row. Now I want to count the number of yellow cells. I don't know VB, so if someone knows a formula method to count the cells, that would be great. Thanks, Marc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cells based on conditional formatting
See Chip Pearson's site for code dealing with CF coloring.
http://www.cpearson.com/excel/CFColors.htm Gord Dibben MS Excel MVP On Wed, 5 Jul 2006 11:01:01 -0700, Marc wrote: hello - I've conditionally formatted a column of cells to a yellow background based on the sum of 5 other cells in the row. Now I want to count the number of yellow cells. I don't know VB, so if someone knows a formula method to count the cells, that would be great. Thanks, Marc |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting cells based on conditional formatting
On Wed, 5 Jul 2006 11:01:01 -0700, Marc wrote:
hello - I've conditionally formatted a column of cells to a yellow background based on the sum of 5 other cells in the row. Now I want to count the number of yellow cells. I don't know VB, so if someone knows a formula method to count the cells, that would be great. Thanks, Marc You'll need to incorporate in your Counting formula the same formula you use in the conditional format. For example, if the yellow background appears if E1 < SUM(A1:D1) then one approach would be to set up a helper column with that formula in it. For example: F1: =E1<SUM(A1:D1) Then copy/drag that down and COUNT the number of TRUE's =COUNTIF(F1:F12,TRUE) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Frame cells with Outline Border | Excel Discussion (Misc queries) | |||
Creating a conditional format for a cell based on another cell's v | Excel Discussion (Misc queries) | |||
conditional formatting based on column | Excel Discussion (Misc queries) | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) |