xROGERx
New Member
- Joined
- Dec 27, 2020
- Messages
- 15
- Office Version
- 2013
- Platform
- 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!!
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!!