COUNTIF By Cell Background Color In Excel
To COUNTIF By Color Please Follow The Step Shown Below With Images.
Go To Formula Tab.
Then Click On Define Name.
You Will See One Dialog Box Get Pop-Up.
In Name Bar Please Add Any Name Without Space Ex: CELLCOLOR.
In Scope Dropdown Please Select According To Your Requirement.
In Comment Box Add Any Comment To Display On Cell Selection.
In Refer To Bar Add This Formula =GET.CELL(38,Sheet12!$A2)
Once This Done Create A Separate Column Called Color Code.
Apply Formula =CELLCOLOR or Whatever Name you Have Given In Name Bar.
Once You Have The Color Code You Can Apply Formula On It As Shown In Image Below.
NOTE: Change Reference According To Your Range & Sheet. This Formula Will Refer To Single Cell In A Sequence Manner.
Click Ok.
Please Check Imag...