Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How To Count The Number Of Cells Highlighted Using Conditional Formatting Feature Present In Format Menu Of Excel???

cells conditional feature format highlighted menu PRESENT
0
Posted

How To Count The Number Of Cells Highlighted Using Conditional Formatting Feature Present In Format Menu Of Excel???

0 CommentsAdd a Comment

1 Answer

0

I have used Conditional Formatting present in the Format Menu to highlight cells in the worksheet with satisfy the condition. Now I want to count the total number of cells highlighted by conditional formattin for each column and display in a cell of the column… Kindly help me with a way to do this…I tried using the interior.colorindex property to count the cells coloured … but no use because conditional formattin doesnot actually change the cell’s formatting it just highlight… Plzzz let me kno how to do..

0 CommentsAdd a Comment
What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.