Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA to count colored cells
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA to count colored cells
hi
see this site for counting CF color with VB..... http://www.cpearson.com/excel/CFColors.htm if you are just starting with VB, see these sites..... http://www.mvps.org/dmcritchie/excel/getstarted.htm http://www.exceltip.com/excel_links.html http://www.excel-vba.com/ do a google.....you'll find more Regards FSt1 "ericahughes" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count cells colored red? | Excel Discussion (Misc queries) | |||
How do you count colored cells? | Excel Worksheet Functions | |||
count colored cells? | Excel Worksheet Functions | |||
Count non-colored cells | Excel Discussion (Misc queries) | |||
Count or sum colored cells | Excel Worksheet Functions |