Re: search a series of rows for a specific formating

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

There's nothing built into excel that allows you to do this. But Chip Pearson
has a routine that will help:

http://www.cpearson.com/excel/colors.htm
Look for: Counting Cells With A Specific Color

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


Harris wrote:
>
> I have a series of cells containing some numbers and the background in some
> of theese cells is red. Can I count theese red cells and have the result in
> another cell?

--

Dave Peterson
.

Relevant Pages

  • Re: search a series of rows for a specific formating
    ... It may be easier to count the cells based on the logic that is used to color ... Biff ... Can I count theese red cells and have the result ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: How can I get an empty cell with a formula
    ... then the cells for that row in columns D - G must have a value. ... This routine works great. ... Is there any way that I can have the Counta of column E equal 0 if there is ... no entry in it?I have a routine that runs when I save the workbook. ...
    (microsoft.public.excel.programming)
  • Re: Repeat a value down a column until a new value comes up
    ... Select all your data and then try running the following routine from David ... On Error Resume Next 'in case no text cells in selection ... > a delimited text file brought into Excel.) ... >>> Edit/Goto/Special followed by Blanks. ...
    (microsoft.public.excel.worksheet.functions)
  • Restore formats in merged cells ...
    ... I have a O.K. routine today that restore format when merged cells are the ... Private Sub Worksheet_Change(ByVal Target As Range) ... .ReadingOrder = xlContext ...
    (microsoft.public.excel.programming)
  • RE: How can I get an empty cell with a formula
    ... then the cells for that row in columns D - G must have a value. ... This routine works great. ... Is there any way that I can have the Counta of column E equal 0 if there is ... no entry in it?I have a routine that runs when I save the workbook. ...
    (microsoft.public.excel.programming)