Conditional formatting a row of cells based on input in one cell

[Jayzon]

Hi
I have a row of cells B2 to O2, i would like to use conditional formatting to color this row based on the input "X" in cell G2. Is this possible ?

Thank you in advance
Jayzon

 

[Fluff]

Glad it's sorted & thanks for the feedback.

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=$G2="X"

 

[Jayzon]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=$G2="X"

Thank you very much
This worked perfectly, is there a way to easy extend this rule to other rows G3-G4 and so on without manually adding the formatting to each row ?

 

[Fluff]

Yes, just apply the rule to B2:O10 or whatever the last row is.

Also please don't forget to update you profile.

 

[Jayzon]

Yes, just apply the rule to B2:O10 or whatever the last row is.

Also please don't forget to update you profile.

Profile updated
Maybe it is because i am pretty novice at this, but when i extended this rule cover all rows fromB2 to P100 the formatting seems random and not based on the value in G2 ?

 

[Fluff]

As long as you use the formula I suggested it should work.

Fluff.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2	8	3	2	10	16	6	14	15	4	10	3	3	8	2	8
3	17	15	14	1	17	x	10	11	8	12	11	3	2	13	3
4	10	15	13	8	5	13	1	7	18	8	17	4	5	10	5
5	10	18	13	4	18	20	2	7	12	12	6	6	2	5	8
6	20	1	15	6	20	x	7	2	4	5	20	7	6	9	18
7	6	16	19	10	4	16	9	14	10	20	12	13	1	20	1
8	14	16	20	12	8	13	19	14	2	5	4	15	13	15	12
9	7	19	20	2	2	2	18	19	13	6	19	5	9	14	14
10	11	14	5	20	5	x	18	14	15	16	16	19	2	13	16
11	2	13	20	4	16	3	6	16	4	3	20	10	6	15	8
Sheet7

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:P11	Expression	=$G2="X"	text	NO

 

[Jayzon]

As long as you use the formula I suggested it should work.

Fluff.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2	8	3	2	10	16	6	14	15	4	10	3	3	8	2	8
3	17	15	14	1	17	x	10	11	8	12	11	3	2	13	3
4	10	15	13	8	5	13	1	7	18	8	17	4	5	10	5
5	10	18	13	4	18	20	2	7	12	12	6	6	2	5	8
6	20	1	15	6	20	x	7	2	4	5	20	7	6	9	18
7	6	16	19	10	4	16	9	14	10	20	12	13	1	20	1
8	14	16	20	12	8	13	19	14	2	5	4	15	13	15	12
9	7	19	20	2	2	2	18	19	13	6	19	5	9	14	14
10	11	14	5	20	5	x	18	14	15	16	16	19	2	13	16
11	2	13	20	4	16	3	6	16	4	3	20	10	6	15	8
Sheet7

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:P11	Expression	=$G2="X"	text	NO

I think the issue is that only row 2 should be formatted of H2 (I changed this to H), and row 3 should be formatted of H3 and so on

 

[Jayzon]

I am having troubel pasting sheet here, is there a way i can attach the sheet ?

 

[Jayzon]

I am not able to install Xl2BB, addin blocked by my organisation