CountByColor to work on Conditionally formatted cells - Need help

[sureng19]

The UDF posted in the forum to count the number of cells of a certain color doesn't work when cells are conditionally formatted. (ex: >3, cell highlight is Green, <2 Red, bet 2-3 Yellow). CountByColor, otherwise works fine for cells with bkground manually colored.

Can someone please help me to get it to work for conditionally formatted cells.

The code I have for CountByColor is as follows:

Please Login or Register  to view this content.

Thanks alot.

[pike]

Hi sureng19
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here