| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Test for shaded cell?
A friend has a worksheet that some cells are shaded, others aren't. The
shaded cells values are to be summed. Right now, he's writing a different formula for each row of data to calculate the sum of the shaded cells. Is there any way to test for a shaded cell and only put it's value into the sum? Somehow to put that in say the first row of the sum column, and then copy it down? Thanks! Shawn -- Join the newest in Fantasy Sports. http://www.6FantasySports.com (this site supports the Victory Junction Gang Camp with a portion of all proceeds) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shaded cells won't print shaded | Excel Worksheet Functions | |||
| tell if a cell is shaded | New Users to Excel | |||
| shaded cell sumation | Excel Discussion (Misc queries) | |||
| Show a row shaded when a cell contains certain data | Setting up and Configuration of Excel | |||
| Hide text in shaded cell | Excel Worksheet Functions | |||
Threaded Mode
