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

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

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

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