Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sherry N. - 07 Feb 2008 16:31 GMT

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?

Signature

Sherry N.

Reply to this Message

Pete_UK - 07 Feb 2008 16:43 GMT

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

> Hello,
> I have a worksheet where I need the cells in Column C to turn yellow if
[quoted text clipped - 7 lines]
> =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?

Reply to this Message

Sherry N. - 07 Feb 2008 18:31 GMT

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

Signature

Sherry N.

> 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
[quoted text clipped - 21 lines]
> > =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?

Reply to this Message

Pete_UK - 07 Feb 2008 18:42 GMT

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. <Sher...@discussions.microsoft.com>
wrote:

> Thanks so much works great. How can I add another condition that would make
> the blank cells have no formatting? Thanks again.
[quoted text clipped - 31 lines]
>
> - Show quoted text -

Reply to this Message

Sherry N. - 07 Feb 2008 18:51 GMT

PERFECT! Thanks again!

Signature

Sherry N.

> Hightlight all the cells again and amend the formula like this:
>
[quoted text clipped - 41 lines]
> >
> > - Show quoted text -

Reply to this Message

Pete_UK - 07 Feb 2008 19:05 GMT

Glad to hear it - thanks for feeding back.

Pete

On Feb 7, 6:51 pm, Sherry N. <Sher...@discussions.microsoft.com>
wrote:

> PERFECT! Thanks again!
> --
[quoted text clipped - 47 lines]
>
> - Show quoted text -

Reply to this Message