COUNTIF By Cell Background Color In Excel

To COUNTIF By Color Please Follow The Step Shown Below With Images.

1. Go To Formula Tab.
2. Then Click On Define Name.
3. You Will See One Dialog Box Get Pop-Up.
4. In Name Bar Please Add Any Name Without Space Ex: CELLCOLOR.
5. In Scope Dropdown Please Select According To Your Requirement.
6. In Comment Box Add Any Comment To Display On Cell Selection.
7. In Refer To Bar Add This Formula =GET.CELL(38,Sheet12!$A2)
8. Once This Done Create A Separate Column Called Color Code.
9. Apply Formula =CELLCOLOR or Whatever Name you Have Given In Name Bar.
10. Once You Have The Color Code You Can Apply Formula On It As Shown In Image Below.
11. NOTE: Change Reference According To Your Range & Sheet. This Formula Will Refer To Single Cell In A Sequence Manner.
12. Click Ok.
13. Please Check Image Below.

• Share on Facebook
• Share on Twitter
• Share on Pinterest
• Share on LinkedIn
• Share via Email
• Share on Tumblr
• Share on Reddit