Forum Discussion
Luca Distefano
Dec 21, 2017Copper Contributor
Countif and if function
I would like to =countif every cell colored in green can someone help?
Thank you in advances and happy holidays to everyone reading this
Hi Luca,
COUNTIF as any other function/formula in Excel works with cells values. Color of the cell is its property, you may pick it up with VBA macro only.
However, if you green your cells using conditional formatting you may count such cells using same condition as in your rule to color the cells.
- Luca DistefanoCopper Contributor
Thank you very much for your help!
- Haytham AmairahSilver Contributor