Tags: background, cells, enter, excel, formula, highlighted, highlighting, microsoft, msdn, number, range, software, values

Count number of cells that are highlighted

On Microsoft » Microsoft Excel

6,119 words with 4 Comments; publish: Fri, 23 May 2008 02:54:00 GMT; (30678.13, « »)

I'd like to have a formula that would allow me to enter a range of values and

it would tell me how many cells have background highlighting (something along

the lines of countif). Can someone assist?

Thanks,

Barb Reinhardt

All Comments

Leave a comment...

  • 4 Comments
    • Hi Barb

      How do you determine which cells have background highlighting? Is it all

      cells on a worksheet, a named range or a particular area?

      Is the background highlighting dynamic (eg the result of conditional

      formatting)?

      What colour(s) do you use for the background highlighting?

      Cheers

      --

      macropod

      [MVP - Microsoft Word]

      "Barb Reinhardt" <BarbReinhardt.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:3DCCAC0E-1E18-4CD9-940A-FD84EBA6FE64.excel.todaysummary.com.microsoft.com...

      > I'd like to have a formula that would allow me to enter a range of values

      and

      > it would tell me how many cells have background highlighting (something

      along

      > the lines of countif). Can someone assist?

      > Thanks,

      > Barb Reinhardt

      #1; Fri, 23 May 2008 02:55:00 GMT
    • Something other than a white background and a black font. It is highlighted

      with a conditional format. Let's say I have selected cells B1:B10. I want

      to know how many are highlighted.

      Thanks

      "macropod" wrote:

      > Hi Barb

      > How do you determine which cells have background highlighting? Is it all

      > cells on a worksheet, a named range or a particular area?

      > Is the background highlighting dynamic (eg the result of conditional

      > formatting)?

      > What colour(s) do you use for the background highlighting?

      > Cheers

      > --

      > macropod

      > [MVP - Microsoft Word]

      >

      > "Barb Reinhardt" <BarbReinhardt.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:3DCCAC0E-1E18-4CD9-940A-FD84EBA6FE64.excel.todaysummary.com.microsoft.com...

      > > I'd like to have a formula that would allow me to enter a range of values

      > and

      > > it would tell me how many cells have background highlighting (something

      > along

      > > the lines of countif). Can someone assist?

      > >

      > > Thanks,

      > > Barb Reinhardt

      >

      >

      #2; Fri, 23 May 2008 02:56:00 GMT
    • Would need to work out which Format conditions (up to 3 in a cell) are true.

      If you already know how the FC's were written it's relatively

      straightforward to calculate them in vba. If not means reading the FC

      formula(s), possibly building a new formula to Evaluate, including if

      necessary the comparison operators. Fair bit of code but again relatively

      straight forward to get it right most of the time (ie all or none of the

      time depending on what you've got).

      To get it always right though involves a lot of code (Evaluate is might not

      work, comparison methods in Excel & VBA are very different depending on what

      you are comparing).

      Regards,

      Peter T

      "Barb Reinhardt" <BarbReinhardt.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:9091A4CE-3722-43A2-83E1-645EDE67C07F.excel.todaysummary.com.microsoft.com...

      > Something other than a white background and a black font. It is

      highlighted

      > with a conditional format. Let's say I have selected cells B1:B10. I

      want

      > to know how many are highlighted.

      > Thanks

      > "macropod" wrote:

      > > Hi Barb

      > >

      > > How do you determine which cells have background highlighting? Is it all

      > > cells on a worksheet, a named range or a particular area?

      > >

      > > Is the background highlighting dynamic (eg the result of conditional

      > > formatting)?

      > >

      > > What colour(s) do you use for the background highlighting?

      > >

      > > Cheers

      > >

      > > --

      > > macropod

      > > [MVP - Microsoft Word]

      > >

      > >

      > > "Barb Reinhardt" <BarbReinhardt.excel.todaysummary.com.discussions.microsoft.com> wrote in

      message

      > > news:3DCCAC0E-1E18-4CD9-940A-FD84EBA6FE64.excel.todaysummary.com.microsoft.com...

      > > > I'd like to have a formula that would allow me to enter a range of

      values

      > > and

      > > > it would tell me how many cells have background highlighting

      (something

      > > along

      > > > the lines of countif). Can someone assist?

      > > >

      > > > Thanks,

      > > > Barb Reinhardt

      > >

      > >

      > >

      #3; Fri, 23 May 2008 02:57:00 GMT
    • Hi Barb,

      You can do this with formulae in cells using the same logic as your

      conditional formatting formulae.

      Cheers

      --

      macropod

      [MVP - Microsoft Word]

      "Barb Reinhardt" <BarbReinhardt.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:9091A4CE-3722-43A2-83E1-645EDE67C07F.excel.todaysummary.com.microsoft.com...

      > Something other than a white background and a black font. It is

      highlighted

      > with a conditional format. Let's say I have selected cells B1:B10. I

      want

      > to know how many are highlighted.

      > Thanks

      > "macropod" wrote:

      > > Hi Barb

      > >

      > > How do you determine which cells have background highlighting? Is it all

      > > cells on a worksheet, a named range or a particular area?

      > >

      > > Is the background highlighting dynamic (eg the result of conditional

      > > formatting)?

      > >

      > > What colour(s) do you use for the background highlighting?

      > >

      > > Cheers

      > >

      > > --

      > > macropod

      > > [MVP - Microsoft Word]

      > >

      > >

      > > "Barb Reinhardt" <BarbReinhardt.excel.todaysummary.com.discussions.microsoft.com> wrote in

      message

      > > news:3DCCAC0E-1E18-4CD9-940A-FD84EBA6FE64.excel.todaysummary.com.microsoft.com...

      > > > I'd like to have a formula that would allow me to enter a range of

      values

      > > and

      > > > it would tell me how many cells have background highlighting

      (something

      > > along

      > > > the lines of countif). Can someone assist?

      > > >

      > > > Thanks,

      > > > Barb Reinhardt

      > >

      > >

      > >

      #4; Fri, 23 May 2008 02:58:00 GMT