| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Selecting shaded cells in a row
I want to exclude the values of cells that are shaded in a summation, e.g. I
have SUM(A9: Z9) = 1000, but I do not want cells F9, M9 and Y9, so I highlight them in, say, green, then manually amend the appropriate cell calculation to deduct these values. Can Excel account for highlighting in this way? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shaded cells won't print shaded | Excel Worksheet Functions | |||
| selecting cells | Excel Discussion (Misc queries) | |||
| Hightlighting crosshairs when selecting cells | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Threaded Mode
