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

Need Help with a VBA subroutine 0
Using FIND to highlight text (with dashes) 4
Indenting every other paragraph in Word at the same time? 0
Adding a comment in a footnote area 1
How to count the numbers in a Word document? 0
if there is a blank ,how to get the blank cell in a range be highlighted 2
Blank Page After Envelope-Label Wizard 5
AppleScript - How do I select a text ? 1

Top