| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally Formatted Cells
I have some cells in a worksheet that are conditionally formatted. I need to
count the number of cells that have green text. How can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditionally Formatted Cells
Did you use a formula to set the conditional formatting? If so, you can use
that formula (might need a little modification) to count how many cells meet the criteria. Use the logic of *why do some cells have green text* to create a formula to count those cells. -- Biff Microsoft Excel MVP "amy" wrote in message ... I have some cells in a worksheet that are conditionally formatted. I need to count the number of cells that have green text. How can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you add the number of conditionally formatted cells?? | Excel Worksheet Functions | |||
| Selecting cells that have been conditionally formatted | Excel Discussion (Misc queries) | |||
| Counting conditionally formatted cells | Excel Worksheet Functions | |||
| Can I count conditionally formatted red cells in Excel 2000 | Excel Discussion (Misc queries) | |||
| how do i concatenate conditionally formatted cells in excel | Excel Worksheet Functions | |||
Linear Mode
