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"))?
570I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
577I 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?
547I 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?
653Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?
648In order to apply the same formatting to every sheet in a workbook in ms-excel what needs to be done?
639Post New MS Excel Microsoft Questions
I have lost my password in ms excel?
How do you insert a row?
What do you call it when you combine two names?
What is an array formula?
How do I customize the ribbon in excel 365?
What is difference between lookup and vlookup?
How do I automatically count rows in excel?
What laptops come with word and excel?
How do I fix character length in excel?
How do I change the default font in excel 2019?
How many rows and columns 2018 excel?
What do you mean by filtering?
Is there a free version of excel?
Which key is used for help in ms excel?
How do you make an excel sheet online?