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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,820
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,089,847
Messages
5,410,734
Members
403,326
Latest member
Phoebee

This Week's Hot Topics

Top