Is there a way to count cells in a range based on fill color?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook that uses the fill color as a dimensionof the data (
currecy of training). I want to automate statistics without counting cells
and entering the number. I would like to do some thing like countif the fill
is red. IS there a way to set the fill value to a variable to count with?
 

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

Function for summing or counting cells based on a specified fill color 2
add value of cells based on the formatted fill color 3
Counting cells with conditional formatting 3
Excel Macro to automatically go to the right of the last colored cell 0
count colored cells in excel 5
countif based on fill color 1
Format cell based on cell color 3
Counting by color 3

Back
Top