The worksheet contains "conditionally formatted" cells.
The "conditions" are different for different cells
Cells "that need attention" are formatted with a red background
I want to count the number of cells with red backgrounds in the worksheet
The worksheet contains "conditionally formatted" cells.
The "conditions" are different for different cells
Cells "that need attention" are formatted with a red background
I want to count the number of cells with red backgrounds in the worksheet
I would use another cell in the same row that mimics the format|Conditional
formatting rules.
Then use count that column.
....maybe =countif(a2:a999,"red")
If you really, really have your heart set on using the conditional formatting,
take a look at Chip Pearson's site for some tips:
http://www.cpearson.com/excel/CFColors.htm
ExcelUser wrote:
>
> The worksheet contains "conditionally formatted" cells.
>
> The "conditions" are different for different cells
>
> Cells "that need attention" are formatted with a red background
>
> I want to count the number of cells with red backgrounds in the worksheet
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks