As much as Conditional Formatting (CF) is good but is some cases it’s a pain in the B….. In the attached small file, I am using a Function to count Red Fonts and it works as it’s supposed to. In Row 2, I have CF’d the number 9, and in my program I use CF on a sheet like this one, to be red and the Function will not recognize it as red font when the formula CountByFontColor is run. Is there a work around CF so that it can be ignored?
If you have a solution could you place it on the attached file.
Thanks
Bookmarks