No. Not in Excel 2008, because you need VBA to retrieve the formats.
Instead of applying formats to the cells, create a new "Kind" column beside
them and enter a digit there to indicate which kind it is.
Then use Conditional Formatting to apply formats based on the value in the
new column.
You can then easily use COUNTIF to count the number of times a value appears
in the "Kind" column.
Hope this helps
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I want to count cells based on the formats. Is this possible?
This email is my business email -- Please do not email me about forum
matters unless you intend to pay!
--
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:
[email protected]
