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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

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
64,627
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,171,280
Messages
5,874,816
Members
433,075
Latest member
DRubio

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