Formula encompassing conditional formating

S

Stuck up north

Is it possible to perform formula functions on unconditional formating of a
cell?

A simple example:
Can I perfom a simple COUNT of number of cells in a range that have
unconditional formating of the cell colour?
 
B

Bob Phillips

The best way to do this is to construct a formula that test for how many
cells meet the conditional formatting condition.

As an example, if the CF tested and coloured any cells that were greater
than 10, then use

=COUNTIF(A2:A200,">10")

or something similar

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top