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

    Oct 24, 2011, 09:41 AM
    Count Shaded Cells with a value of X in it
    Hi, I need help with creating a function to count cells that are shaded and have a value of X in them in a range of selected cells. I have tried the several vba macros that count shaded cells but I need to to go one step further and only count the shaded cells that have a value within them such as X. Thanks
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Oct 26, 2011, 04:39 PM
    I would never implement a "coloring" method of counting. By whatever criteria you used to color the cells, I would make sure that criteria was properly reflected in the data and then create formulas that can assess the data the same way.

    By that I mean, marking a row "paid" by coloring it green is a very human thing to do, but it's terrible data. There should be a column where that "paid" status is entered and thus easily referenced without super plumbing trying to analyze formatting.

    Is that possible? Can you update your workbook to properly include all data exclusive of any colorizations?

    Anyway, testing the value of a cell is easy. Other than "X", what would the other values be? It might be as simple as testing if the cell is blank or not. But testing for "X", very easy once the full context is seen.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. See if you can manually demonstrate a logic of what rows to count that doesn't require color analysis, too. Why are the cells colored?
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!

Count certain coloured cells in excel [ 1 Answers ]

Hi I have numerous coloured cells on an excel worksheet and I want to make a formula to count the different colours... ie all the red ones, the green ones etc... Which formula would I use

Using Count to get the number of cells in a column that contain text [ 4 Answers ]

I'm trying to just count the number of cells in a column that have text in them. I used a formula given in one of the previous questions and got a return of #NUM. The fomula I tried was =Sumproduct((Callsign <>"")/Count if (Callsign, Callsign & ""))

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 cells with colored font. [ 2 Answers ]

I'm have a spread sheet in Excel that has some cells fonts in red to indicate poor numbers. I want to know how I can count how many cells on the spread sheet have red font. I tried to do a COUNTIF command but I'm not sure if this is will count the colored font data.

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...

View more questions Search