Ask Experts Questions for FREE Help !
Ask

In Excel how to count the cell content by fill color?

Asked Mar 12, 2012, 01:00 PM — 1 Answer
Ok below mention question in different situation like I want to count the cell color with the cell content which is some tag number(eg:- 120-ps-010,120-ps-13,......... So on , so here I can't use the condition function because there are a lot of tag , please guide any of us how to solve this issue

Search this Thread
Share |
1 Answer
JBeaucaire's Avatar
JBeaucaire Posts: 5,373, Reputation: 5036
Software Expert
  
#2

Mar 13, 2012, 09:04 PM


What version of Excel are you using? Did you try pressing F1 in Excel and searching for COUNT COLOR?
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Color fill does not show on Excel 2007 worksheet [ 3 Answers ]

When I use color fill to color the background of a cell, it does not show on the worksheet on the monitor, but it does print out shaded.

How to count shell color in excel ? [ 1 Answers ]

Please help me.

Excel - Count how many cells have a certain color [ 1 Answers ]

Is there a formula to count how many cells within a row have a certain color. For Instance if I have A1 to M1 filled in with text and 8 are colored yellow then I want my result in N1 to say 8. Any way to do this?

How to count the cells in excel with different fill pattern styles [ 2 Answers ]

Hi I want to count the cells in excel with different fill pattern styles. How is it possible. Can anyone post the function for this purpose like counting coloured cells. I tried a lot , but I got failed. Here I got a function to count cells filled solid, but it is not working...is it...

Excel: Deleted cell content but link is still there [ 3 Answers ]

When I delete text from a cell where the text was a hyperlink, it does go away, but when I go to type new text in the cell, the new text is hyperlinked as the former text was. How can I stop this from happening? Thanks!

View more Spreadsheets questions Search