Mass copy of Conditional formatting

Dear all!
My question is how to easily copy the format of conditionally formatted cells?
I would define the formatting with a formula.
Because as soon as I name either the cell to be formatted or the reference cell, it becomes an absolute reference, so the hair cross drag solution can be forgotten. I want the format of a certain cell in an array to match the value in the same position of another array of the same size.
In the example, in cell A1, if the value of K1 is 5, only A1 should be highlighted.
Then B2 should respond to L1, C1 to M1, etc., up to J10-T10.
I hope I have explained clearly.
I know it could be done individually cell by cell, but I think there should be some smart solution in such a smart program.

Does the value have to be 5, or is it just cells that are not blank?

Please MANUALLY fill in rows 2 and 3 so that we can see what we are aiming for.

Is this what you want?

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1											5
2														2
3
4
5
6												3
7																		4
8
9
10																		1

Sheet: Munka1

If so, the rule is:

=K1<>""

and the Applies to box needs this: =$A$1:$J$10

Because as soon as I name either the cell to be formatted or the reference cell, it becomes an absolute reference, so the hair cross drag solution can be forgotten.

You are clearly a novice with CF. It's not greatly user-friendly, but once you learn how to use it effliciently, you'll find out that this statement is false.

However, I always set formatting for the origin cell (top left of the range) and use the Applies to box to set the range. I do NOT drag copy formatting.

Please provide a completed table - do this MANUALLy to show what you want. There is only one cell with the value of 5 in your grid.

Did what I suggested above do what you want?

So is this what you want?

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
13											5
14														2
15
16
17
18												3
19														5				4
20
21
22													5					1

Sheet: Munka1

In my solution above, simply change the rule to this:

=K1=5

and apply it in the same way.

Please try

CF_rule =K1=5

and the Applies to box needs this: =$A$1:$J$10

Hans - I offered that suggestion in post #7.

Waterstride - is this now resolved? If not, please provide a more extensive sample workbook with all requirements mocked up manually.

Ali, Post 7 and 8 crossed on me.
Post #7 was not yet visible when I posted post #8.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

Originally Posted by HansDouwe

Post #7 was not yet visible when I posted post #8.

It was posted a full five minutes before, so maybe you'd had the thread open for a while without refreshing the page?

Not to worry.

If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.