Conditional Formating

[yellowcabguy]

I have a colulm (X) that contains either a 1 or a 2

If COlumn X =2, I want to shade all the cells in that row (A thru X) in grey

Any thoughts

 

[njimack]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1																								2
2
3																								2
4
5																								2
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =$X1=2	Abc
B1	1. / Formula is =$X1=2	Abc
C1	1. / Formula is =$X1=2	Abc
D1	1. / Formula is =$X1=2	Abc
E1	1. / Formula is =$X1=2	Abc
F1	1. / Formula is =$X1=2	Abc
G1	1. / Formula is =$X1=2	Abc
H1	1. / Formula is =$X1=2	Abc
I1	1. / Formula is =$X1=2	Abc
J1	1. / Formula is =$X1=2	Abc
K1	1. / Formula is =$X1=2	Abc
L1	1. / Formula is =$X1=2	Abc
M1	1. / Formula is =$X1=2	Abc
N1	1. / Formula is =$X1=2	Abc
O1	1. / Formula is =$X1=2	Abc
P1	1. / Formula is =$X1=2	Abc
Q1	1. / Formula is =$X1=2	Abc
R1	1. / Formula is =$X1=2	Abc
S1	1. / Formula is =$X1=2	Abc
T1	1. / Formula is =$X1=2	Abc
U1	1. / Formula is =$X1=2	Abc
V1	1. / Formula is =$X1=2	Abc
W1	1. / Formula is =$X1=2	Abc
X1	1. / Formula is =$X1=2	Abc
A2	1. / Formula is =$X1=2	Abc
B2	1. / Formula is =$X1=2	Abc
C2	1. / Formula is =$X1=2	Abc
D2	1. / Formula is =$X1=2	Abc
E2	1. / Formula is =$X1=2	Abc
F2	1. / Formula is =$X1=2	Abc
G2	1. / Formula is =$X1=2	Abc
H2	1. / Formula is =$X1=2	Abc
I2	1. / Formula is =$X1=2	Abc
J2	1. / Formula is =$X1=2	Abc
K2	1. / Formula is =$X1=2	Abc
L2	1. / Formula is =$X1=2	Abc
M2	1. / Formula is =$X1=2	Abc
N2	1. / Formula is =$X1=2	Abc
O2	1. / Formula is =$X1=2	Abc
P2	1. / Formula is =$X1=2	Abc
Q2	1. / Formula is =$X1=2	Abc
R2	1. / Formula is =$X1=2	Abc
S2	1. / Formula is =$X1=2	Abc
T2	1. / Formula is =$X1=2	Abc
U2	1. / Formula is =$X1=2	Abc
V2	1. / Formula is =$X1=2	Abc
W2	1. / Formula is =$X1=2	Abc
X2	1. / Formula is =$X1=2	Abc
A3	1. / Formula is =$X1=2	Abc
B3	1. / Formula is =$X1=2	Abc
C3	1. / Formula is =$X1=2	Abc
D3	1. / Formula is =$X1=2	Abc
E3	1. / Formula is =$X1=2	Abc
F3	1. / Formula is =$X1=2	Abc
G3	1. / Formula is =$X1=2	Abc
H3	1. / Formula is =$X1=2	Abc
I3	1. / Formula is =$X1=2	Abc
J3	1. / Formula is =$X1=2	Abc
K3	1. / Formula is =$X1=2	Abc
L3	1. / Formula is =$X1=2	Abc
M3	1. / Formula is =$X1=2	Abc
N3	1. / Formula is =$X1=2	Abc
O3	1. / Formula is =$X1=2	Abc
P3	1. / Formula is =$X1=2	Abc
Q3	1. / Formula is =$X1=2	Abc
R3	1. / Formula is =$X1=2	Abc
S3	1. / Formula is =$X1=2	Abc
T3	1. / Formula is =$X1=2	Abc
U3	1. / Formula is =$X1=2	Abc
V3	1. / Formula is =$X1=2	Abc
W3	1. / Formula is =$X1=2	Abc
X3	1. / Formula is =$X1=2	Abc
A4	1. / Formula is =$X1=2	Abc
B4	1. / Formula is =$X1=2	Abc
C4	1. / Formula is =$X1=2	Abc
D4	1. / Formula is =$X1=2	Abc
E4	1. / Formula is =$X1=2	Abc
F4	1. / Formula is =$X1=2	Abc
G4	1. / Formula is =$X1=2	Abc
H4	1. / Formula is =$X1=2	Abc
I4	1. / Formula is =$X1=2	Abc
J4	1. / Formula is =$X1=2	Abc
K4	1. / Formula is =$X1=2	Abc
L4	1. / Formula is =$X1=2	Abc
M4	1. / Formula is =$X1=2	Abc
N4	1. / Formula is =$X1=2	Abc
O4	1. / Formula is =$X1=2	Abc
P4	1. / Formula is =$X1=2	Abc
Q4	1. / Formula is =$X1=2	Abc
R4	1. / Formula is =$X1=2	Abc
S4	1. / Formula is =$X1=2	Abc
T4	1. / Formula is =$X1=2	Abc
U4	1. / Formula is =$X1=2	Abc
V4	1. / Formula is =$X1=2	Abc
W4	1. / Formula is =$X1=2	Abc
X4	1. / Formula is =$X1=2	Abc
A5	1. / Formula is =$X1=2	Abc
B5	1. / Formula is =$X1=2	Abc
C5	1. / Formula is =$X1=2	Abc
D5	1. / Formula is =$X1=2	Abc
E5	1. / Formula is =$X1=2	Abc
F5	1. / Formula is =$X1=2	Abc
G5	1. / Formula is =$X1=2	Abc
H5	1. / Formula is =$X1=2	Abc
I5	1. / Formula is =$X1=2	Abc
J5	1. / Formula is =$X1=2	Abc
K5	1. / Formula is =$X1=2	Abc
L5	1. / Formula is =$X1=2	Abc
M5	1. / Formula is =$X1=2	Abc
N5	1. / Formula is =$X1=2	Abc
O5	1. / Formula is =$X1=2	Abc
P5	1. / Formula is =$X1=2	Abc
Q5	1. / Formula is =$X1=2	Abc
R5	1. / Formula is =$X1=2	Abc
S5	1. / Formula is =$X1=2	Abc
T5	1. / Formula is =$X1=2	Abc
U5	1. / Formula is =$X1=2	Abc
V5	1. / Formula is =$X1=2	Abc
W5	1. / Formula is =$X1=2	Abc
X5	1. / Formula is =$X1=2	Abc

 

[ammdumas]

- Highlight the first row (A thru X) and then go into conditional formatting
- Choose the 'use a formula option' and in the box that appears type =$X1=2
- Hit the Format button and select your formatting options
- 'OK' yourself out of that function
- Copy and Paste FORMATTING ONLY the first row all the way down thru all rows that need this conditional formatting.

Give it a whirl

 

[yellowcabguy]

Thanks works great