I'd like to count cells with TRUE value in conditional formatting

tedmed

New Member
Joined
Sep 16, 2019
Messages
5
Using countif doesn't work because formula in CF (= i don't wanna enter conditional formatting always) is too long with many other functions and there are 4 cells. Is there any other way to get results of formulas in CF outside CF?
Thank you.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,476
Office Version
365
Platform
Windows
You would need to create a formula that replicates all the relevant CF rules.
Otherwise it would need a macro, as a UDF won't work as that cannot see CF formats, but you would need to trigger the macro somehow & changes in CF wont trigger it.
 

Forum statistics

Threads
1,078,364
Messages
5,339,760
Members
399,321
Latest member
ladeko

Some videos you may like

This Week's Hot Topics

Top