Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 07:40 PM
Scarface
 
Posts: n/a
Default enable Excel to recognize Cell Colors

we have been trying to use available functions in excel to create a report
(on their own or included with other functions), but none of them were able
to give us the correct resault. if we could have a function that can be
embedded in a fourmula to recognize a CELL COLOR in the database, it'd be
alot easier and we could do alot more with this software.

please see if this is possible.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

  #2   Report Post  
Old May 18th 05, 07:51 PM
Chip Pearson
 
Posts: n/a
Default

No built in function can test for cell color. See
www.cpearson.com/excel/colors.htm for some VBA code that might
help.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Scarface" wrote in message
...
we have been trying to use available functions in excel to
create a report
(on their own or included with other functions), but none of
them were able
to give us the correct resault. if we could have a function
that can be
embedded in a fourmula to recognize a CELL COLOR in the
database, it'd be
alot easier and we could do alot more with this software.

please see if this is possible.


----------------
This post is a suggestion for Microsoft, and Microsoft responds
to the
suggestions with the most votes. To vote for this suggestion,
click the "I
Agree" button in the message pane. If you do not see the
button, follow this
link to open the suggestion in the Microsoft Web-based
Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions



  #3   Report Post  
Old May 18th 05, 07:55 PM
Ron de Bruin
 
Posts: n/a
Default

Hi Scarface

My Beta version 2.1 of EasyFilter can filter on Colors(not CF colors)
Maybe useful
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Chip Pearson" wrote in message ...
No built in function can test for cell color. See www.cpearson.com/excel/colors.htm for some VBA code that might help.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Scarface" wrote in message ...
we have been trying to use available functions in excel to create a report
(on their own or included with other functions), but none of them were able
to give us the correct resault. if we could have a function that can be
embedded in a fourmula to recognize a CELL COLOR in the database, it'd be
alot easier and we could do alot more with this software.

please see if this is possible.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions







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
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
Can I copy a combo box in Excel 2002 with a relative cell link? Bozo Excel Discussion (Misc queries) 1 February 17th 05 02:05 AM
In MS Excel, how do I fill in a column with the same cell from se. krempin Excel Worksheet Functions 2 February 9th 05 08:43 PM
I have typed in an excel cell and cannot advance to next cell by . aneruth Excel Discussion (Misc queries) 1 January 14th 05 02:34 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017