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"))?
619I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
700I 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?
627I 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?
776Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?
720In order to apply the same formatting to every sheet in a workbook in ms-excel what needs to be done?
691Post New MS Excel Microsoft Questions
What is the difference between merging and splitting cells?
What is a foreign key in excel?
How to compare combination of columns in excel?
Why is data validation important?
What do you mean by filtering?
How do you copy just the formatting in excel?
How do I apply a conditional formula in excel?
What is the name manager in excel?
Does excel and word come with windows 10?
How is the new excel worksheet added?
What is vba in excel?
How do I extend the trendline in excel 2019?
Can't find excel on windows 10?
What are the 3 types of cell references in excel?
Can you use excel as a database?