Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
up to 7 functions? | Excel Worksheet Functions | |||
Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |