Try this:

Select cols A and B

Click Format Conditional Formatting

Under Condition 1, make the settings as:
Formula Is| =SUM($A1:$B1)=150
Click Format button Patterns tab Light brown? OK
Click OK at the main dialog

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"mike lowry" <mike wrote in 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...