I would rather have the total red cells show up in a cell versus a message. That said, this is the best video I've seen so far on the topic. All the other videos I've seen use a named range to use an old function. The seems to work with one column, but not with a table like he's done here.
Just made a similar video where the total number of red cells show up at the end of each row. Excel VBA Macro: Count and List the Number of (Conditonally Formatted) Cells at the End of Each Row th-cam.com/video/PmdyyEFCJFU/w-d-xo.html
Just made a video on this! Excel VBA Macro: Count and List the Number of (Conditonally Formatted) Cells at the End of Each Row th-cam.com/video/PmdyyEFCJFU/w-d-xo.html
I would rather have the total red cells show up in a cell versus a message. That said, this is the best video I've seen so far on the topic.
All the other videos I've seen use a named range to use an old function. The seems to work with one column, but not with a table like he's done here.
Thank you for your feedback!
Just made a similar video where the total number of red cells show up at the end of each row. Excel VBA Macro: Count and List the Number of (Conditonally Formatted) Cells at the End of Each Row
th-cam.com/video/PmdyyEFCJFU/w-d-xo.html
why my excel sheet not excepting VBA Macro code?
Hope you were able to get it working
Like one row has different conditionally colored cells... than end that cell one cell has count that how many cell ls of specific colored..
I can make a video on this topic
Just made a video on this! Excel VBA Macro: Count and List the Number of (Conditonally Formatted) Cells at the End of Each Row
th-cam.com/video/PmdyyEFCJFU/w-d-xo.html
I want to put counting conditionally colored cell like a formula...
Do you have a specific example?
not very usefull if the value is not in a cell