Sort by font color with Excel
 

Hello,

I designed an excel spreadsheet for expense reporting purposes. Since our
employees use a combination of company provided credit cards and their own
cash theyre required submit 2 separate expense reports accordingly. This
helps me determine their actual reimbursement. Obviously they're complaining
about the time it takes to complete both reports. Is it possibly to develop
a formula that could identify (and print) amounts according to their font
color? For example, if they were to report their cash expenses in "red" and
credit card expenses in "black", the report would know how to total the
amounts according to font. Going a step further, they could also print 2
separate pages displaying their individual expenses by font.

Sort by font color with Excel
 

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mr. G." wrote in message
...
Hello,

I designed an excel spreadsheet for expense reporting purposes. Since our
employees use a combination of company provided credit cards and their own
cash they're required submit 2 separate expense reports accordingly. This
helps me determine their actual reimbursement. Obviously they're
complaining
about the time it takes to complete both reports. Is it possibly to
develop
a formula that could identify (and print) amounts according to their font
color? For example, if they were to report their cash expenses in "red"
and
credit card expenses in "black", the report would know how to total the
amounts according to font. Going a step further, they could also print 2
separate pages displaying their individual expenses by font.

Sort by font color with Excel
 

Unfortunately I'm unable access that link. But thank you anyways.

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mr. G." wrote in message
...
Hello,

I designed an excel spreadsheet for expense reporting purposes. Since our
employees use a combination of company provided credit cards and their own
cash they're required submit 2 separate expense reports accordingly. This
helps me determine their actual reimbursement. Obviously they're
complaining
about the time it takes to complete both reports. Is it possibly to
develop
a formula that could identify (and print) amounts according to their font
color? For example, if they were to report their cash expenses in "red"
and
credit card expenses in "black", the report would know how to total the
amounts according to font. Going a step further, they could also print 2
separate pages displaying their individual expenses by font.

Sort by font color with Excel
 

On Jan 29, 6:44*pm, Mr. G. wrote:
Unfortunately I'm unable access that link. *But thank you anyways.



"Bob Phillips" wrote:
Seehttp://www.xldynamic.com/source/xld.ColourCounter.htmlfor a working
solution

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mr. G." wrote in message
...
Hello,

I designed an excel spreadsheet for expense reporting purposes. *Since our
employees use a combination of company provided credit cards and their own
cash they're required submit 2 separate expense reports accordingly. *This
helps me determine their actual reimbursement. *Obviously they're
complaining
about the time it takes to complete both reports. *Is it possibly to
develop
a formula that could identify (and print) amounts according to their font
color? *For example, if they were to report their cash expenses in "red"
and
credit card expenses in "black", the report would know how to total the
amounts according to font. *Going a step further, they could also print 2
separate pages displaying their individual expenses by font.- Hide quoted text -

- Show quoted text -

someone mentioned conditional formating to me on a similar question.
maybe someone out there knows about it?
and
that website did not work for me either

Sort by font color with Excel
 

I tried the Bob's website and got this message...
"This account has exceeded it's bandwidth quota and has been temporarily disabled."
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"hierba de gatos"
...
On Jan 29, 6:44 pm, Mr. G. wrote:
Unfortunately I'm unable access that link. But thank you anyways.



"Bob Phillips" wrote:
Seehttp://www.xldynamic.com/source/xld.ColourCounter.htmlfor a working
solution
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)

Sort by font color with Excel
 

Mr G,

As Jim noted, my site has exceeded its allotted bandwidth. It will be
available again Friday.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jim Cone" wrote in message
...

I tried the Bob's website and got this message...
"This account has exceeded it's bandwidth quota and has been temporarily
disabled."
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"hierba de gatos"
...
On Jan 29, 6:44 pm, Mr. G. wrote:
Unfortunately I'm unable access that link. But thank you anyways.



"Bob Phillips" wrote:
Seehttp://www.xldynamic.com/source/xld.ColourCounter.htmlfor a working
solution
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my
addy)

Sort by font color with Excel
 

Chip Pearson's site is available now.

http://www.cpearson.com/excel/colors.htm


Gord Dibben MS Excel MVP

On Tue, 29 Jan 2008 15:59:34 -0800, Mr. G.
wrote:

Hello,

I designed an excel spreadsheet for expense reporting purposes. Since our
employees use a combination of company provided credit cards and their own
cash they’re required submit 2 separate expense reports accordingly. This
helps me determine their actual reimbursement. Obviously they're complaining
about the time it takes to complete both reports. Is it possibly to develop
a formula that could identify (and print) amounts according to their font
color? For example, if they were to report their cash expenses in "red" and
credit card expenses in "black", the report would know how to total the
amounts according to font. Going a step further, they could also print 2
separate pages displaying their individual expenses by font.