| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif cell has shading
I have a simple worksheet with rows where column A is a person's name and then columns B through AC are different statistics. I shade certain cells manually based on a criteria. Once those cells are shaded, I want in column AD for there to be a countif statement that counts the number of cells shaded on that row. It seems easy enough but I can't figure out how to do it! If anybody could provide any example I would greatly appreciate it. Thanks! -- ChrisF79 ------------------------------------------------------------------------ ChrisF79's Profile: http://www.excelforum.com/member.php...o&userid=27549 View this thread: http://www.excelforum.com/showthread...hreadid=470743 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to sort the data by cell shading or cell color? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Cell Shading | Excel Discussion (Misc queries) | |||
| shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
Threaded Mode
