View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.