View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. G. Mr. G. is offline
external usenet poster
 
Posts: 4
Default 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.