| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count highlighted cells
Hi, Is there a formula that can help me the number of highlighted cells in a row? -- PASSWORD37 ------------------------------------------------------------------------ PASSWORD37's Profile: http://www.excelforum.com/member.php...o&userid=31245 View this thread: http://www.excelforum.com/showthread...hreadid=509199 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count highlighted cells
Hi!
http://cpearson.com/excel/colors.htm You're better off using the logic behind why the cells are colored to craft a formula. For example, the cells are colored if the values are less than 10. =COUNTIF(A1:J1,"<10") Biff "PASSWORD37" wrote in message ... Hi, Is there a formula that can help me the number of highlighted cells in a row? -- PASSWORD37 ------------------------------------------------------------------------ PASSWORD37's Profile: http://www.excelforum.com/member.php...o&userid=31245 View this thread: http://www.excelforum.com/showthread...hreadid=509199 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignoring highlighted cells | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
| Counting highlighted cells? | Excel Discussion (Misc queries) | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
Linear Mode
