I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return thecolor of the interior for each cell in a range? I would like to do something like: =countif(b1:b10, cell("interior","red"))?
617I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
697I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?
623I have created some clever formulas, and I don not want anyone else to see them. Is it possible to hide the formulas but display the results?
774Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?
718Why do you use dbm instead of ncf in the northern blotting and what are the pre-treatments required for this paper to be used?
1120why the word trasfection is prefers for transfer of genetic material through non viral particles ineukaryote not for prokaryote?
1217
Is VT100 Server will support TCP/IP protocol?
Can we install Oracle database in VT100 Server?
If my server is Sun Solaris can i use like VT100 Server?
Suppose there are two requests for 2 different pages of same site and from 2 different browsers, How Web server recognise the different request and send result to the exact sender browsers.
what is the principle involved in Biometry?
How a component can be placed on Windows?
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
How to connect to a remote database using Applet?
How to display names of all components in a Container?
Can you give names of Container classes?
What are the differences between Java 1.0 and Java 2.0?
Name the components that are termed to be Heavy-weight component but available in Light-weight components?
What are the restrictions imposed by a Security Manager on Applets?.
How listener identify that the event came from a particular object?
Can we call virtual funciton in a constructor ?