1. Select your range.
2. Go to Format Conditional Formatting
3. Select "Formula Is" and put:
=INDIRECT("rc",0)="x"
4. Press the Format radio button and format as desired.
HTH
Jason
Atlanta, GA
-----Original Message-----
Can I do a conditional formatting on a range if the
value
in one cell in the range = X
in other words can I format the back ground for line 5
if
C5 = X
.
|