Counting Colored Cells that are Conditional Formated
 

Hello All,
In Excel 2003, I am looking for a way to count colored (conditional formated
cells) in a column.

Desired outcome....
Counted cells #'s in (A1) where the colored cells are between A:2 and A:4000

TFTH

Counting Colored Cells that are Conditional Formated
 

You can use the same formula which is used in Conditional Formatting for
highlighting the cells. If you might have used the [Cell value] is in
Conditional formatting other than [Formula is] then explain about the
conditions.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"tom" wrote:

Hello All,
In Excel 2003, I am looking for a way to count colored (conditional formated
cells) in a column.

Desired outcome....
Counted cells #'s in (A1) where the colored cells are between A:2 and A:4000

TFTH

Counting Colored Cells that are Conditional Formated
 

Thank you for your response, but I can not see to figure out how to manage
your recommendation. Can you provide an example?

TFTH

"Ms-Exl-Learner" wrote:

You can use the same formula which is used in Conditional Formatting for
highlighting the cells. If you might have used the [Cell value] is in
Conditional formatting other than [Formula is] then explain about the
conditions.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"tom" wrote:

Hello All,
In Excel 2003, I am looking for a way to count colored (conditional formated
cells) in a column.

Desired outcome....
Counted cells #'s in (A1) where the colored cells are between A:2 and A:4000

TFTH

try this code, if your worksheet name is sheet1, otherwise replace your sheet name instead of sheet1

Private Sub Workbook_Open()
Dim i, j As Integer
j = 0
ActiveWorkbook.Sheets("sheet1").Select
For i = 2 To 4000
If Worksheets("sheet1").Range("A" & i).FormatConditions.Count < 0 Then
j = j + 1

End If
Next i

Worksheets("sheet1").Range("A" & 1) = j
End Sub

all the best

Counting Colored Cells that are Conditional Formated
 

How you would have highlighted the cells using the Conditional Formatting?

--------------------
(Ms-Exl-Learner)
--------------------

"tom" wrote in message
...
Thank you for your response, but I can not see to figure out how to manage
your recommendation. Can you provide an example?

TFTH

"Ms-Exl-Learner" wrote:

You can use the same formula which is used in Conditional Formatting for
highlighting the cells. If you might have used the [Cell value] is in
Conditional formatting other than [Formula is] then explain about the
conditions.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"tom" wrote:

Hello All,
In Excel 2003, I am looking for a way to count colored (conditional
formated
cells) in a column.

Desired outcome....
Counted cells #'s in (A1) where the colored cells are between A:2 and
A:4000

TFTH