1. Select columns A and B.
2. Go to Format Conditional Formatting
3. Under Condition 1 select "Formula Is" and put:
=$A1+$B1=150
4. Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA


-----Original Message-----
trying to conditional format 2 colums where the cells
are dependent. So if
cell a1 +b1=150, i would like for both cells to be
coloured, but i need to
replicate this for 200 other cells in each colum...i
have tried paste
special, but the other cells just use the answer from
the first cell to
derive their answer...
.