Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default How do I use cell color in formulas?

Is there some way I can create a function that uses the cell color? What I
want to do is something like

COUNT IF cell-color = magenta
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul B
 
Posts: n/a
Default How do I use cell color in formulas?

Mike, have a look here for a way to do it,

http://www.cpearson.com/excel/colors.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Mike" wrote in message
...
Is there some way I can create a function that uses the cell color? What I
want to do is something like

COUNT IF cell-color = magenta



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
Excel: Clear all cell entries EXCEPT formulas? newsgal Excel Discussion (Misc queries) 6 March 18th 06 12:46 AM
Formulas in a cell sabrol Excel Discussion (Misc queries) 3 August 11th 05 05:39 PM
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Excel formulas based upon the color shading of a cell? DGBG Excel Worksheet Functions 1 April 12th 05 10:35 PM


All times are GMT +1. The time now is 12:41 PM.

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"