Counting Cells Based on Color

G

Grok

Is it possible to use a function such as countif to count cells based on
the background color of the cells?

The cells in the spreadsheet are color coordinated to indicate a
different status or phase. I need to calculate percentages based on
what the color is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match table shading (color) to Visio color/Transparency 1
Function for summing or counting cells based on a specified fill color 3
Excel does not accept text format! 0
Pulling background color from master to other sheet 2
shading a cell or group of cells based on value 5
add value of cells based on the formatted fill color 3
Dealing with a Pivot Table (when I don't want to) 0
Needs help combining functions. 3

Top