Counting a Column
in [General]
|
From: dwake on 10 May 2010 10:45 I am trying to do a count of a column....problem is....I want to count whether the cell is shaded in green and if there is a date in the cell as well. so if a cell is shaded in green and has a date, that would count as one. Any ideas?
From: T. Valko on 10 May 2010 10:54 What does the green shade mean? Why is a cell shaded green? If the cells are shaded green using conditional formatting then you can use the same logic that applies the cf to also count those cells. -- Biff Microsoft Excel MVP "dwake" <dwake(a)discussions.microsoft.com> wrote in message news:AF9A7986-2412-4B0D-9606-FAF55BCA42BC(a)microsoft.com... >I am trying to do a count of a column....problem is....I want to count > whether the cell is shaded in green and if there is a date in the cell as > well. so if a cell is shaded in green and has a date, that would count as > one. Any ideas?
From: dwake on 10 May 2010 13:31 It means completed. I have one column I am trying to manage two different criteria. One is date of an appointment, and also whether that appointment was completed or not. I am not using conditional formatting to shade in the cells. "T. Valko" wrote: > What does the green shade mean? Why is a cell shaded green? If the cells are > shaded green using conditional formatting then you can use the same logic > that applies the cf to also count those cells. > > -- > Biff > Microsoft Excel MVP > > > "dwake" <dwake(a)discussions.microsoft.com> wrote in message > news:AF9A7986-2412-4B0D-9606-FAF55BCA42BC(a)microsoft.com... > >I am trying to do a count of a column....problem is....I want to count > > whether the cell is shaded in green and if there is a date in the cell as > > well. so if a cell is shaded in green and has a date, that would count as > > one. Any ideas? > > > . >
From: T. Valko on 10 May 2010 16:59 See this: http://www.cpearson.com/Excel/colors.aspx -- Biff Microsoft Excel MVP "dwake" <dwake(a)discussions.microsoft.com> wrote in message news:4C52D27E-E981-413C-B350-C0B05FBAFEF8(a)microsoft.com... > It means completed. I have one column I am trying to manage two different > criteria. One is date of an appointment, and also whether that > appointment > was completed or not. I am not using conditional formatting to shade in > the > cells. > > "T. Valko" wrote: > >> What does the green shade mean? Why is a cell shaded green? If the cells >> are >> shaded green using conditional formatting then you can use the same logic >> that applies the cf to also count those cells. >> >> -- >> Biff >> Microsoft Excel MVP >> >> >> "dwake" <dwake(a)discussions.microsoft.com> wrote in message >> news:AF9A7986-2412-4B0D-9606-FAF55BCA42BC(a)microsoft.com... >> >I am trying to do a count of a column....problem is....I want to count >> > whether the cell is shaded in green and if there is a date in the cell >> > as >> > well. so if a cell is shaded in green and has a date, that would count >> > as >> > one. Any ideas? >> >> >> . >>
|
Pages: 1 Prev: Insert rows when data changes Next: Office 2007 + formatting cells |