I am trying to count all cell in green fill color using this simple . . .
To count all cells with green fill color in a table, you can use the following formula: =COUNTIF(range,CELL("color",cell)=3) Replace range with the range of cells you want to count, and cell with the reference to a cell within that range. Heres an example: =COUNTIF(A1:C10,CELL("color",A1)=3)
more
|