Forum Discussion
Solved
Creating a chart/graph on the total of highlighted, conditionally formatted cells?
I have a series of data in a table, example below: It is formatted so that if the completion date is more than 3 months before the deadline, it highlights green, and less than 3 months high...
- Add a new column called something like "isCompleted" with a 0/1 value or true/false
You can then easily reference this for the bar or pie charts.
You can as well have the formatting based on this value instead of having the logic in the conditional formatting. The conditional formatting would be just check if the value next is a 0 or 1
Add a new column called something like "isCompleted" with a 0/1 value or true/false
You can then easily reference this for the bar or pie charts.
You can as well have the formatting based on this value instead of having the logic in the conditional formatting. The conditional formatting would be just check if the value next is a 0 or 1
You can then easily reference this for the bar or pie charts.
You can as well have the formatting based on this value instead of having the logic in the conditional formatting. The conditional formatting would be just check if the value next is a 0 or 1
AdamChmielewski I can confirm this worked perfectly! Thank you!
