Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Possible to extrapolate a value based on formatting?
Sort of reverse conditional formatting?
I know it's really stupid, but I'm helping out w/a legacy spreadsheet - a list of IDs which have been 'hand-colored' one of three fill colors based on one of three possible status codes (which codes are maintained in a database). (Trying to talk them into a simple report or at least a data extract from that db, etc., but....!) ANYWAY - bottom line, in the interim: is there a way to check the formatting to infer a value, headed toward counting totals for same, e.g. - count all cells filled red, count all cells filled yellow. Thanx for your time! Wendy HB |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Possible to extrapolate a value based on formatting?
I'd use a userdefined function in another cell that relates to the color of the
fill. Then I could use a formula like =sumif() based on the original range and that helper column. Chip Pearson has some code he http://cpearson.com/excel/colors.htm And he also has a way to count or sum based on formatting: Look for: Counting Cells With A Specific Color or Summing The Values Of Cells With A Specific Color on that same web site. WendyHB wrote: Sort of reverse conditional formatting? I know it's really stupid, but I'm helping out w/a legacy spreadsheet - a list of IDs which have been 'hand-colored' one of three fill colors based on one of three possible status codes (which codes are maintained in a database). (Trying to talk them into a simple report or at least a data extract from that db, etc., but....!) ANYWAY - bottom line, in the interim: is there a way to check the formatting to infer a value, headed toward counting totals for same, e.g. - count all cells filled red, count all cells filled yellow. Thanx for your time! Wendy HB -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Possible to extrapolate a value based on formatting?
Dave - This looks like EXACTLY what I need (and so timely, too!)
You're NOT MS tech support, eh wot? Thx again, WendyHB "Dave Peterson" wrote: I'd use a userdefined function in another cell that relates to the color of the fill. Then I could use a formula like =sumif() based on the original range and that helper column. Chip Pearson has some code he http://cpearson.com/excel/colors.htm And he also has a way to count or sum based on formatting: Look for: Counting Cells With A Specific Color or Summing The Values Of Cells With A Specific Color on that same web site. WendyHB wrote: Sort of reverse conditional formatting? I know it's really stupid, but I'm helping out w/a legacy spreadsheet - a list of IDs which have been 'hand-colored' one of three fill colors based on one of three possible status codes (which codes are maintained in a database). (Trying to talk them into a simple report or at least a data extract from that db, etc., but....!) ANYWAY - bottom line, in the interim: is there a way to check the formatting to infer a value, headed toward counting totals for same, e.g. - count all cells filled red, count all cells filled yellow. Thanx for your time! Wendy HB -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Possible to extrapolate a value based on formatting?
In general, I think I'd ask google (and google newsgroups) before going to most
help desks <vbg. WendyHB wrote: Dave - This looks like EXACTLY what I need (and so timely, too!) You're NOT MS tech support, eh wot? Thx again, WendyHB "Dave Peterson" wrote: I'd use a userdefined function in another cell that relates to the color of the fill. Then I could use a formula like =sumif() based on the original range and that helper column. Chip Pearson has some code he http://cpearson.com/excel/colors.htm And he also has a way to count or sum based on formatting: Look for: Counting Cells With A Specific Color or Summing The Values Of Cells With A Specific Color on that same web site. WendyHB wrote: Sort of reverse conditional formatting? I know it's really stupid, but I'm helping out w/a legacy spreadsheet - a list of IDs which have been 'hand-colored' one of three fill colors based on one of three possible status codes (which codes are maintained in a database). (Trying to talk them into a simple report or at least a data extract from that db, etc., but....!) ANYWAY - bottom line, in the interim: is there a way to check the formatting to infer a value, headed toward counting totals for same, e.g. - count all cells filled red, count all cells filled yellow. Thanx for your time! Wendy HB -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I extrapolate from a given set of data? | Excel Worksheet Functions | |||
how do I extrapolate values from a graph in excel? | Excel Discussion (Misc queries) | |||
extrapolate data from series | Excel Worksheet Functions | |||
Extrapolate to zero (n) rather than forecast x units | Charts and Charting in Excel | |||
How can I extrapolate a y-value in a linear chart? | Excel Worksheet Functions |