Highlight all the cells in column C that you want this to apply to, with C2
being the first cell in this range. Click on Format | Conditional
Formatting, select Formula Is in the first panel, and enter this formula in
the next panel:

=$B2<$G$128

Click on the Format button then select the Patterns tab to change the
background colour to yellow, then OK your way out.

Hope this helps.

Pete

"Sherry N." wrote in message
...
Hello,
I have a worksheet where I need the cells in Column C to turn yellow if
the
cell in Column B is less than a cell in Column G. I used this formula for
the
conditional formatting in C2 =IF($B$2<$G$128,1,0) and it does work.
However I
need the whole column to have the same conditional formatting when I paste
formats it just pastes the exact same formula. I want the next one to be
=If($B3<$G128,1,0). Is there a way I can paste formats that would use step
value or would I have to do the condtional formatting for each cell?

--
Sherry N.