Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Sum Formula based on color

I have a spreadsheet in which costs are color coded. I would like to put a
function on place that will sum the costs based on the color of the text.
Can anyone help with this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default Sum Formula based on color

google
sum color:excel

http://www.google.com/search?sourcei...+color%3aexcel

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sunlvr13" wrote in message
...
I have a spreadsheet in which costs are color coded. I would like to put a
function on place that will sum the costs based on the color of the text.
Can anyone help with this?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Sum Formula based on color

See:
http://www.cpearson.com/excel/Colors.aspx
--
Gary''s Student - gsnu200804
Reply
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
create a formula based on cell color pcwolfie Excel Worksheet Functions 2 August 23rd 08 07:26 AM
can a formula add color based on a date and time? Outbacker Excel Discussion (Misc queries) 1 August 29th 06 04:14 PM
How do I change color pattern based upon a formula within a cell? aemuk Excel Worksheet Functions 1 June 16th 06 11:18 PM
color code cells based on golddigger formula Network Guru Excel Discussion (Misc queries) 2 March 23rd 06 03:47 AM
adding color to cells based on a formula fyrfytr265 Excel Worksheet Functions 2 November 1st 05 05:17 PM


All times are GMT +1. The time now is 06:16 AM.

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

About Us

"It's about Microsoft Excel"