hossboss85
New Member
- Joined
- Mar 25, 2009
- Messages
- 2
Hi all. I've been using this board a ton since starting my internship six months ago. MrExcel and OZGrid have pretty much made me the "Excel Guy" at work, so...many thanks!
I couldn't find a solution to this problem, though.
I have a huge list of hedge funds and I've added several buttons that apply conditional formatting based on, e.g., "fund assets < $100mm," "minimum investment < $250k," etc--the formatting just colors the cell background red.
Conditional formatting is weird in that it doesn't really "color" the cell (the color index is still blank, "-4142"). Even so, I can apply a sort to drop all red-colored cells to the bottom of the list. But when I tried adding code to count the number of NON-red-colored cells (the ones that "passed the test"), there's no way to differentiate between "Pass" and "Fail" funds.
Is there any property of a conditionally-formatted cell that actually *does* change (since color doesn't) that would let me count it separately from the rest of the cells?
Thanks for your help! Much appreciated!
I couldn't find a solution to this problem, though.
I have a huge list of hedge funds and I've added several buttons that apply conditional formatting based on, e.g., "fund assets < $100mm," "minimum investment < $250k," etc--the formatting just colors the cell background red.
Conditional formatting is weird in that it doesn't really "color" the cell (the color index is still blank, "-4142"). Even so, I can apply a sort to drop all red-colored cells to the bottom of the list. But when I tried adding code to count the number of NON-red-colored cells (the ones that "passed the test"), there's no way to differentiate between "Pass" and "Fail" funds.
Is there any property of a conditionally-formatted cell that actually *does* change (since color doesn't) that would let me count it separately from the rest of the cells?
Thanks for your help! Much appreciated!