Counting highlighted cells

K

Kassie

If I want to count how many highlighted cells there are in a row or column is
there a formula that will do that for me - there will be no numbers in these
cells just highlighted. I would want each highlighted cell to count as 1.
 
B

Brad Vogt

What caused these cells to be highlighted? Is there a conditional format
involved? I don't think that a formula can refer to formatting from cells.
 
B

Brad Vogt

=CELL("format", A2) will tell you in that cell what the format is for cell
A2. Highlighted cells do not show as anything different unless it is also
formatted differently (ie. General instead of Date/Time)

If you can make the cell function work to distinguish which cells are
highlighted in another area, you may be able to count the cells that are
highlighted in another area by the results of the cell function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary based on highlighted cells 4
Can you sum cell amounts that are highlighted 3
Count Highlited Cells 3
Is there a way to count the number of highlighted cells in a col? 2
Need to highlight cells in special order 0
SUMCOLOR with conditional formatting not working 3
calculate sum of highlighted cells in a column 4
how to count number of highlighted cells in column 5

Top