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 |
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 |
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 |
All times are GMT +1. The time now is 06:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com