View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Formula encompassing conditional formating

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)


"Stuck up north" wrote in message
...
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?