Ask Experts Questions for FREE Help !
Ask
    nishanth77's Avatar
    nishanth77 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 12, 2012, 01:00 PM
    In Excel how to count the cell content by fill color?
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    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?
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


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 questions Search