Countif function

jonwhite

Board Regular
Joined
Mar 29, 2005
Messages
69
Hi All,

I have searched for this but can't find any thing. Is it possible to do a Countif function against the fill colour of a cell ie =countif(A1,Red fill colour)

Many Thanks in advance

Jon.

**EDIT** sorry, I did not click your second link... that look like just what I need Thank you
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Thankyou for that, The reason I say a countif function is that once I can determine the colour of each cell i wish to use a datafilter to filter off each clour and add a comment in the righthand cell to the filled cell. is there any onther advice you can give

Thanks again
Jon
 
Upvote 0
Basically, what those links do is create a kind of "CountIf" function that work based on color. So it would work like any other Excel function.

So if you imagine that you could do what you want with a CountIf function (if it did color), you should be able to do it with the User Defined Functions in the links provided.
 
Upvote 0

Forum statistics

Threads
1,217,383
Messages
6,136,264
Members
450,001
Latest member
KWeekley08

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top