I'm trying to replicate the colour bars in table two, in table one. It's important for the presentation I'm doing I use numbers, not percentages. Basically the data bar represents how the proportion of how many people responded to answer in their group.
Table two is easy enough, just just zero as minimum, 1 as maximum.
The first table, requires a small formula, a sum of the total responses in the group. I can do this, however it wont permit relative references. I get a 'You cannot use relative references in Conditional Formatting criteria for color scales, data bars, and icon set' message.
File can be downloaded here - https://easyupload.io/tfygrp
Is there a cheap trick around this? I'm looking to around 20 tables in this format, having to manually formula every one would take forever.
Table two is easy enough, just just zero as minimum, 1 as maximum.
The first table, requires a small formula, a sum of the total responses in the group. I can do this, however it wont permit relative references. I get a 'You cannot use relative references in Conditional Formatting criteria for color scales, data bars, and icon set' message.
File can be downloaded here - https://easyupload.io/tfygrp
Is there a cheap trick around this? I'm looking to around 20 tables in this format, having to manually formula every one would take forever.