| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Shaded Cells
Have received your email - will get back to you tomorrow (bit late
here). Pete On May 5, 1:46*am, BrettPotts wrote: I have a spreadsheet with some cells which are shaded cells and some that have values in them. On each row i would like a cell that will calculate the number of coloured or shaded cells (excluding the cells with text or values in them). What formula could i use and would the formula work if i needed to calculate colums as well? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shaded cells won't print shaded | Excel Worksheet Functions | |||
| Calculating percentage of Shaded Cells in a row | Excel Worksheet Functions | |||
| How do I get gridlines in shaded cells? | Excel Discussion (Misc queries) | |||
| Not printing shaded cells... | Excel Discussion (Misc queries) | |||
| Selecting shaded cells in a row | Excel Worksheet Functions | |||
Threaded Mode
