View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MS-Exl-Learner MS-Exl-Learner is offline
external usenet poster
 
Posts: 132
Default 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