Hi!
I have a sheet with column I containing numerical data and the default automatic color scale applied to it. I would like for the cells in column A to be automatically formatted the same way as those of column I for better readability (e.g. to have A3 have the same background color as I3), and it would be a lot more convenient if I could do it in an automated way so any changes to the formatting of column I would immediately apply to column A as well.
Is there a way to do this? I tried looking for an answer on the forums but I couldn’t find anything applicable to my wants; apologies if it’s already been answered and I just couldn’t find it.
(Just in case it’s relevant, I’m using version 25.8.2.2, which should be the latest.)
Thanks!