In the attached file, I need Count (in col. M) of all the cells in a row (range B2: L2) that are highlighted in pink, how do I do that using some excel function
File is attached here for reference
@Jan Karel Pieterse
Can you show me the way to do this?
I happened to see your post and made a search on the topic remembering that I have seen (but not used) cell coloring logic somewhere before.
I found this. Maybe this gives you something to dwell upon:
Mind you I know nothing more of the subject or ablebits.
In your case that could be
just use logic of your conditional formatting rules. Please see attached.