VBA to count colored cells

E

ericahughes

I have never used a VBA, but I am a really quick learner and a self taught
excel user. What I have is a conditional format that highlights the row in
blue if the G cell contains the word *lab*. Now what I need to do is have
these cells not be counted in my graphs. I am using a countif formula - such
as COUNTIF">1200" for time ranges. I want the rows with teh word lab in
column G to NOT count in this. I was thinking a VBA could do this, but quite
honestly I do not know how to do this. Any help would really be appriciated
-thanks!
 

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

count colored cells in excel 5
vba to delete rows 1
Count range of cells if not next to each other 0
Count rows based on multiple criteria 3
How to count cells that are highlighted by conditional formatting 1
Excel Sorting / Filtering Colored Cells 1
Counting cells that contain a substring 3
Counting Colored Cells that are Conditional Formated 3

Top