[Q] Conditionally copy the formatting of other cells?

English
, ,
#1

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!

#2

Have you tried to simply extend the rangevand use Absolute adressing in the condition like $A1>0
If you have a custom format for Range I1:I10 and edit this to A1:A10,I1:I10 both use the same.
This should work, if the condition itself is not relating to columns with relative addressing.
.
It will not work if you create a new conditional format.

#3

CF of type »Colorscale« can only exclusivly applied to an cellrange with numerical values, there is (actually) no way to reference this CF into other Cellranges!

1 Like
#4

@karolus So you’re saying the only way to do what I want is to hardcode a color scale from scratch instead of using the built-in color scale and then apply Wanderer’s suggestion?

#5

not exactly, but yes! @Wanderer 's suggestion doesn’t work in case Colorscale

#6

Yes, that item i missed…

#7

I’m not sure what the “not exactly” was for, do you have a more elegant solution to offer?

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.