ExcelBanter - How to COUNT coloured in Conditional Formatted Cells

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to COUNT coloured in Conditional Formatted Cells (https://www.excelbanter.com/excel-discussion-misc-queries/191069-how-count-coloured-conditional-formatted-cells.html)

John Scott

How to COUNT coloured in Conditional Formatted Cells

Is it possible to COUNT coloured in Conditional Formatted Cells?

Jonah

David Biddulph[_2_]

How to COUNT coloured in Conditional Formatted Cells

Use COUNTIF, with the same condition as you set for your Conditional
Formatting.
--
David Biddulph

"John Scott" wrote in message
...
Is it possible to COUNT coloured in Conditional Formatted Cells?

Jonah

John Scott

How to COUNT coloured in Conditional Formatted Cells

Can I count colours in cells?

How?

Jonah
============

David Biddulph wrote:

Use COUNTIF, with the same condition as you set for your Conditional
Formatting.
Is it possible to COUNT coloured in Conditional Formatted Cells?

David Biddulph[_2_]

How to COUNT coloured in Conditional Formatted Cells

Not with a formula. Only with VBA.
--
David Biddulph

"John Scott" wrote in message
...
Can I count colours in cells?

How?

Jonah
============

David Biddulph wrote:

Use COUNTIF, with the same condition as you set for your Conditional
Formatting.
Is it possible to COUNT coloured in Conditional Formatted Cells?

All times are GMT +1. The time now is 08:09 PM.