Ask Your Question
0

Conditional Format (copy / paste possible?) [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-11 09:56:25.270059

1 Answer

Sort by » oldest newest most voted
0

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

Question Tools

1 follower

Stats

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

Seen: 358 times

Last updated: Aug 29 '16