Ask Your Question

Conditional Format (copy / paste possible?)

asked 2016-08-28 21:42:35 +0200

JG101 gravatar image

Is there a way to copy an entire conditional format so I do not have to re-enter every time. I have 32 conditions I would like to create under one conditional format: is this possible?

example: i have 20 names and I would like to color code each name a different color. I have to add a condition for each name with color background which mean 20 different conditions within the Original Conditional Format.

I do not want to do this for every document, how can i copy Conditional format and use for any purpose.

I'm trying to achieve a color visual to quickly identify names in different columns.

thank you in advance for any help provided

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-08-29 01:06:54 +0200

m.a.riosv gravatar image

I think copying the format of a cell with the conditional format on a cell out of the range of that conditional format, and then edit the range of the cf.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-08-28 21:42:35 +0200

Seen: 128 times

Last updated: Aug 29 '16