[GOOGLE SHEET] How can I count cells based on their color (formatted condition)

xROGERx

New Member
Joined
Dec 27, 2020
Messages
15
Office Version
  1. 2013
Platform
  1. Windows
Hi there guys,

I am currently working on a project with data for 7 different variables. Each variable has its unique set of parameters that we considered "acceptable" or "good". To make it easier on us when analyzing this data we have applied conditional formatting to these cells using just three basics colors: Green, Orange, and Red.

Now, I want to create a chart based on the number of entries that has conditional formatting for each of those colors, and of course, I want to do it for each variable.

I already have the parameters but I don´t know how to do this.

For example, for each variable, I want to know the number of entries in Green, Orange, and Red.

Thoughts?

I would love if I could do this without any coding or script as I am not very good at that.

Cheers!!
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
To make it easier, this is what I have...
2021-08-01 16_02_20-Window.jpg


And this is what I want...
2021-08-01 16_02_27-Window.jpg
 
Upvote 0
The simplest method is probably to use COUNTIFS formulas based on the same conditions you set for the conditional formatting.
 
Upvote 0

Forum statistics

Threads
1,223,993
Messages
6,175,838
Members
452,675
Latest member
duongtruc1610

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
Back
Top