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? |
#2
|
|||
|
|||
Hi Al,
See Bob Phillips ColourCounter page at: http://www.xldynamic.com/source/xld.ColourCounter.html and see Chip Pearson's Functions for Working With Cell Colors at: http://www.cpearson.com/excel/colors.htm --- Regards, Norman "Al" wrote in message ... 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? |
#3
|
|||
|
|||
Norman, I need to simplify the answer. These solutions (appear to) require
VBA programming, and mine is non-existant! mAny more suggestions please? "Norman Jones" wrote: Hi Al, See Bob Phillips ColourCounter page at: http://www.xldynamic.com/source/xld.ColourCounter.html and see Chip Pearson's Functions for Working With Cell Colors at: http://www.cpearson.com/excel/colors.htm --- Regards, Norman "Al" wrote in message ... 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? |
#4
|
|||
|
|||
"Al" wrote...
Norman, I need to simplify the answer. These solutions (appear to) require VBA programming, and mine is non-existant! mAny more suggestions please? .... The only other suggestion would be to use a different spreadsheet program. Excel provides *NO* built-in (worksheet function) means of determining cell background or text color. If you need to do this, you *MUST* use VBA or (much more cumbersome, infelxible and error-prone) XLM functions. |
#5
|
|||
|
|||
Thanks Harlan, looks like I'd better start learning VBA!! Any suggestions
where to start? "Harlan Grove" wrote: "Al" wrote... Norman, I need to simplify the answer. These solutions (appear to) require VBA programming, and mine is non-existant! mAny more suggestions please? .... The only other suggestion would be to use a different spreadsheet program. Excel provides *NO* built-in (worksheet function) means of determining cell background or text color. If you need to do this, you *MUST* use VBA or (much more cumbersome, infelxible and error-prone) XLM functions. |
#6
|
|||
|
|||
Hi Al,
See David McRitchie's introduction notes at: http://www.mvps.org/dmcritchie/excel/getstarted.htm The notes include links to tutorials and other development sources. --- Regards, Norman "Al" wrote in message ... Thanks Harlan, looks like I'd better start learning VBA!! Any suggestions where to start? "Harlan Grove" wrote: "Al" wrote... Norman, I need to simplify the answer. These solutions (appear to) require VBA programming, and mine is non-existant! mAny more suggestions please? .... The only other suggestion would be to use a different spreadsheet program. Excel provides *NO* built-in (worksheet function) means of determining cell background or text color. If you need to do this, you *MUST* use VBA or (much more cumbersome, infelxible and error-prone) XLM functions. |
Reply |
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) |