Count non-colored cells

  • Thread starter Thread starter Ken G
  • Start date Start date
K

Ken G

I have a sheet that highlights cells in a range if any of
those cells contain values from a manually entered range
using the "countif" function and conditional formatting.

How do I count the number of cells which have been
conditionally formatted - with a fill color.
 
-----Original Message-----
I have a sheet that highlights cells in a range if any of
those cells contain values from a manually entered range
using the "countif" function and conditional formatting.

How do I count the number of cells which have been
conditionally formatted - with a fill color.
.
Click to expand...
Sorry - the Subject Line should have been "Count colored cells"
 
Hi
though this is possible it's a little bit complicated. Why not use the same
criteria in a formula as you have don in the conditional format dialog
()e.g. use COUNTIF)
 
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

Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
Counting the number of rows based on the color 2
Counting Colored Cells that are Conditional Formated 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
=Countif(range, criteria) 2
Excel JUMP FROM SEARCH BAR TO RESULT 3
Countif Conditions - Use of conditions that vary by cell value 1

Back
Top