ExcelBanter - Countif cell is conditionally formatted

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Countif cell is conditionally formatted (https://www.excelbanter.com/excel-worksheet-functions/233660-countif-cell-conditionally-formatted.html)

RicG

Countif cell is conditionally formatted

Each row of a table is conditionally formatted to show the largest number in
the row. I would like to count the total number of highlighted cells in each
column.

David Biddulph[_2_]

Countif cell is conditionally formatted

=COUNTIF(A1:A10,MAX(A1:A10))
--
David Biddulph

"RicG" wrote in message
...
Each row of a table is conditionally formatted to show the largest number
in
the row. I would like to count the total number of highlighted cells in
each
column.

All times are GMT +1. The time now is 10:16 AM.