Formula encompassing conditional formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting update issue 5
Excel VBA 1
Excel Conditional Formatting Removal 7
Formula for Dates and CF Colour then convert to Text 3
Count how many times conditional formatted cells are positive 1
Excel 2007 conditional formatting & cell colour. 2
Excel Named Ranges and Conditional Format 3
Conditional Formatting 3

Back
Top