Need help with conditional formatting.

[Eddielion]

Hello everyone. I need some help with conditional formatting. I'm trying to conditional format horizontally. My search numbers are in columns B10:G10. I would like to highlight the numbers that its looking for in columns BM10:DN10. and then I would like to copy it down to perform the same function, to look at the numbers in B11:G11 and search and highlight in BM11:DN11. and repeat all the way down.

I appreciate whoever can help, and for any help I can get.
Thank you.
Eddie

 

[dreid1011]

Does this look like the results you expect?

Using this rule:

 

[Eddielion]

Yes it does. Do I need to select the cells where I would like the formula to go. and if so, which cells would they be?

 

[MARK858]

Change the ranges to suit

Book1
	BY
12
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
BM10:DN15	Expression	=SUM(COUNTIF(BM10,$B10:$F10))	text	NO

Book1
	B	C	D	E	F
10	27	9	33	47	22
11	46	8	21	5	7
12	15	31	21	37	10
13	24	13	15	19	46
14	11	3	31	17	18
15	48	50	46	48	40
Sheet1

Book1
	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW
10	14	23	21	10	31	33	42	15	7	27	19
11	45	43	10	13	26	48	43	41	48	22	27
12	15	38	44	41	27	9	17	12	9	30	24
13	15	46	20	25	3	4	13	17	12	22	31
14	45	10	25	27	37	13	26	5	47	10	36
15	30	42	33	50	3	9	27	40	19	40	16
16	12	31	41	7	9	9	22	49	30	36	8
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
BM10:DN15	Expression	=SUM(COUNTIF(BM10,$B10:$F10))	text	NO

 

[dreid1011]

Yes it does. Do I need to select the cells where I would like the formula to go. and if so, which cells would they be?

Select your range BM10:DNxx and then go to Conditional Formatting > New Rule > use a formula to determine which cells to format.

Then use either my formula or Mark's and pick your formatting.

 

[Eddielion]

Thank you very much Dreid. It worked perfectly. Is there a way I can copy the conditional format down to the rest of the rows?

 

[dreid1011]

Thank you very much Dreid. It worked perfectly. Is there a way I can copy the conditional format down to the rest of the rows?

Did you only select row 10 the first time? You can select the entire range you want it to apply to, ie: BM10:DN30, then create the rule. Or go to Conditional Formatting > Manage Rules and change the Applies To range to match ALL the rows you want it to cover.

 

[Eddielion]

Thank you again Dreid. Thats exactly what I did. Its working great now, thank you so much.
I appreciate all your help.

Eddie

 

[Eddielion]

Mark thank you, I appreciate your help also.
Eddie

 

[dreid1011]

You're welcome, and happy to help.