Counting highlighted cells
 

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.

Counting highlighted cells
 

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.

"Kassie" wrote:

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.

Counting highlighted cells
 

=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.

"Kassie" wrote:

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.