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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

jonwhite

Board Regular
Joined
Mar 29, 2005
Messages
69
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
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,374
Office Version
  1. 365
Platform
  1. Windows
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.
 

Forum statistics

Threads
1,136,927
Messages
5,678,621
Members
419,776
Latest member
mikelowski

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
Top