Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |