LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill color and font color icons do not work in excel huer59 Excel Discussion (Misc queries) 0 November 29th 07 01:06 PM
How do I sort a column of different font colors by color? Jack Excel Worksheet Functions 1 July 20th 07 10:28 AM
Sort or sub-total by Fill color or font color Excel_seek_help Excel Discussion (Misc queries) 1 April 27th 06 09:01 PM
My fill color and font color do not work in Excel Std Edition 2003 chapstick Excel Discussion (Misc queries) 1 September 11th 05 08:48 PM
Can you sort Excel data by font color? Help Me Sort Excel Discussion (Misc queries) 2 December 21st 04 10:35 PM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"