Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Count
I have a spead sheet with 25 rows and 90 columns. These rows have been Conditionaly formated in such a way that there are 4 distince groups. For example Row 1 has numbers ranging from 1 to 400 My conditional format was that if the cell value was between 1 to 100 -- Fill the cell with the color blue If the cell value was between 101 to 200 -- Fill the cell with the color yellow If the cell value was between 201 to 300 -- Fill the cell with the color green If the cell value was between 301 to 400 -- Don't fill the cell with any color The result game me what I wanted now Is there any way in excel where the program can give me a count of the blue cells in a row, yellow cells in a row and green cells in a row? I don't want to sit and manually count them because I am sure I will make silly mistakes like double counting a cell or forgeting to count 1 of them. thanks -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=503701 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Count
You can’t actually count the coloured cells using formulas – but you can count using the same conditions as you used for the conditional formatting, e.g. for row 2, assuming your columns start at A. =COUNTIF(A2:DL2,"0")-COUNTIF(A2:DL2,"100") then =COUNTIF(A2:DL2,"100")-COUNTIF(A2:DL2,"200") etc. -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=503701 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Cell Count
CF cells are difficult, but it can be done. See
http://xldynamic.com/source/xld.CFConditions.html -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "bombayterror" wrote in message news:bombayterror.2206ze_1137878476.4551@excelforu m-nospam.com... I have a spead sheet with 25 rows and 90 columns. These rows have been Conditionaly formated in such a way that there are 4 distince groups. For example Row 1 has numbers ranging from 1 to 400 My conditional format was that if the cell value was between 1 to 100 -- Fill the cell with the color blue If the cell value was between 101 to 200 -- Fill the cell with the color yellow If the cell value was between 201 to 300 -- Fill the cell with the color green If the cell value was between 301 to 400 -- Don't fill the cell with any color The result game me what I wanted now Is there any way in excel where the program can give me a count of the blue cells in a row, yellow cells in a row and green cells in a row? I don't want to sit and manually count them because I am sure I will make silly mistakes like double counting a cell or forgeting to count 1 of them. thanks -- bombayterror ------------------------------------------------------------------------ bombayterror's Profile: http://www.excelforum.com/member.php...o&userid=22855 View this thread: http://www.excelforum.com/showthread...hreadid=503701 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count on cell for each time it is changed | Excel Discussion (Misc queries) | |||
I need to keep a count of the times a cell is changed | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) |