Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill color and font color icons do not work in excel | Excel Discussion (Misc queries) | |||
How do I sort a column of different font colors by color? | Excel Worksheet Functions | |||
Sort or sub-total by Fill color or font color | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
Can you sort Excel data by font color? | Excel Discussion (Misc queries) |