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"))?
588I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?
643I 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?
594I 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?
718Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?
681In order to apply the same formatting to every sheet in a workbook in ms-excel what needs to be done?
665Post New MS Excel Microsoft Questions
How can I enter the symbol for the new euro currency in my spreadsheet?
Is excel 365 the same as excel 2016?
How many types of work in ms excel?
How do you delete hidden tabs in excel?
What is scenario planning used for?
What is countif function in excel?
Where can I find solver in excel?
What common problems do a collection of spreadsheets created by end users share with the typical file system?
How do I randomize a list of names in excel?
What is cell style in excel?
How do you enter data into a spreadsheet?
Why is pivot table used?
How do I fix a name error in excel?
How do I create a scenario summary report in excel?
How do I compare text in excel?