Good Evening,
I have two columns of data. A percentage column and a Volume column.
My percentage column is conditionally formatted to turn green if the value is higher than the goal (cell B116).
I want to get the total volume amount in the column next to it if the percentage is above the goal.
Basically, if a value in column B is green, I want to automatically get the total of the volume next to it in cell C117. Any help would be appreciated. Thank you!
