Conditional Formatting
 

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.

Conditional Formatting
 

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.

Conditional Formatting
 

Thanks so much works great. How can I add another condition that would make
the blank cells have no formatting? Thanks again.
--
Sherry N.


"Pete_UK" wrote:

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.

Conditional Formatting
 

Hightlight all the cells again and amend the formula like this:

=AND($C2<"",$B2<$G$128)

Hope this helps.

Pete


On Feb 7, 6:31*pm, Sherry N.
wrote:
Thanks so much works great. How can I add another condition that would make
the blank cells have no formatting? Thanks again.
--
Sherry N.



"Pete_UK" wrote:
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.- Hide quoted text -

- Show quoted text -

Conditional Formatting
 

PERFECT! Thanks again!
--
Sherry N.


"Pete_UK" wrote:

Hightlight all the cells again and amend the formula like this:

=AND($C2<"",$B2<$G$128)

Hope this helps.

Pete


On Feb 7, 6:31 pm, Sherry N.
wrote:
Thanks so much works great. How can I add another condition that would make
the blank cells have no formatting? Thanks again.
--
Sherry N.



"Pete_UK" wrote:
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.- Hide quoted text -

- Show quoted text -

Conditional Formatting
 

Glad to hear it - thanks for feeding back.

Pete

On Feb 7, 6:51*pm, Sherry N.
wrote:
PERFECT! Thanks again!
--
Sherry N.



"Pete_UK" wrote:
Hightlight all the cells again and amend the formula like this:

=AND($C2<"",$B2<$G$128)

Hope this helps.

Pete

On Feb 7, 6:31 pm, Sherry N.
wrote:
Thanks so much works great. How can I add another condition that would make
the blank cells have no formatting? Thanks again.
--
Sherry N.

"Pete_UK" wrote:
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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -