How to count colored cells in Excel

How to count colored cells in Excel. How to count cells that have been manually coloured in Excel. This will not work on those cells that have a background colour due to conditional formatting. Check out my free templates and templates with code are available for purchase for $50 USD
easyexcelanswers.com/templates.html
Are you struggling to update your Microsoft SQL Server data?
I recommend using well-known Excel to update and manage your data in SQL Server using the SQL Spreads Excel add-in.
Click sqlspreads.com/?pid=barbhenderson to find out how SQL Spreads works best for non-technical end users and download our free 14-day trial. You will get two months free when purchasing an annual subscription using our link.

Check out my online training easyexcelanswers.com/courses.html


Code
Function CountColorIf(Samplecell As Range, bArea As Range) As Long
Dim bAreacell As Range
Dim fillcolor As Long
Dim colorcount As Long

fillcolor = Samplecell.Interior.Color
For Each bAreacell In bArea
If bAreacell.Interior.Color = fillcolor Then
colorcount = colorcount + 1
End If
Next bAreacell
CountColorIf = colorcount
End Function

For more help visit my website easyexcelanswers.com or email me at [email protected].

Contact me regarding customizing this template for your needs.

Click for online Excel Consulting calendly.com/easyexcelanswers

I am able to provide online help on your computer at a reasonable rate.

amazon.com/shop/barbhenderson

Check out my next one-hour Excel Webinar
crowdcast.io/easyexcelanswers

I use a Blue condensor Microphone to record my videos, here is the link
amzn.to/37gyyGa

Check out Crowdcast for creating your webinars
app.linkmink.com/a/crowdcast/83

If you need to buy Office 2019 follow
amzn.to/2VX5dv8

I use Tube Buddy to help promote my videos
Check them out
Tubebuddy.com/easyexcelanswers

Follow me on Facebook
facebook.com/easyexcel.answers

TWEET THIS VIDEO youtu.be/DY_ieB9NEYY

Follow me on twitter
easyexcelanswers

IG @barbhendersonconsulting

You can help and generate a translation to you own language
youtube.com/timedtext_cs_panel?c=UCFH2kZykqt-VX…

*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.