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