(Msg. 1) Posted: Thu Nov 05, 2009 3:56 am
Post subject: Conditional Format Range of Cells Archived from groups: microsoft>public>excel>misc (more info?)
Hi, I am using Excel 2007 and trying to apply conditional formatting as
follows:
If number in column B is greater than number in column D, format text in
column A
If number in column B is less than number in column D, format text in column
C.
So if B1 > C1, format A1, then if B2<C2, format D2, then if B3>C3, format
A3, and so on.
I am able to format text in cell A1 if the number in B1 is greater than C1.
I also figured out how to apply this format to all cells in column A, but
only based on values in B1 & C1.
Is there a way to specify the formual in conditional formatting so that it
compares row by row without entering a new conditional format rule for each
row?
(Msg. 2) Posted: Thu Nov 05, 2009 4:42 am
Post subject: RE: Conditional Format Range of Cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
When you are writing the rule, make sure the row reference is relative ($B3)
and not absolute ($B$3). This will allow the rule to adapt to each row you
copy it to. I'm afraid I don't use 2007 myself, or I would be clearer in my
guidance.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"tommcbrny" wrote:
> Hi, I am using Excel 2007 and trying to apply conditional formatting as
> follows:
>
> If number in column B is greater than number in column D, format text in
> column A
> If number in column B is less than number in column D, format text in column
> C.
>
> So if B1 > C1, format A1, then if B2<C2, format D2, then if B3>C3, format
> A3, and so on.
>
> I am able to format text in cell A1 if the number in B1 is greater than C1.
> I also figured out how to apply this format to all cells in column A, but
> only based on values in B1 & C1.
>
> Is there a way to specify the formual in conditional formatting so that it
> compares row by row without entering a new conditional format rule for each
> row?
>
> Thank you,
> Tom
(Msg. 3) Posted: Thu Nov 05, 2009 8:05 am
Post subject: Re: Conditional Format Range of Cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Tommcbrny,
> Is there a way to specify the formual in conditional formatting so that it
> compares row by row without entering a new conditional format rule for each
> row?
Just select all cells you need the conditional format for and set the formula
up for the selected cell (the white-ish one) using cell references without $
signs in them where appropriate.
So if you are on row 2, set the formulas so they point to the cell(s) on row 2.
Excel will adjust themfor the other cells automatically just like it does when
you copy a formula.
(Msg. 4) Posted: Thu Nov 05, 2009 8:11 am
Post subject: RE: Conditional Format Range of Cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I tried doing this, but notice in 2007 that it specifies an absolute
reference by default and goes back to the absolute reference even if I change
to a relative reference and apply the change. As soon as I click "Apply", it
reverts to the absolute reference.
Thank you for the suggestion though.
"Luke M" wrote:
> When you are writing the rule, make sure the row reference is relative ($B3)
> and not absolute ($B$3). This will allow the rule to adapt to each row you
> copy it to. I'm afraid I don't use 2007 myself, or I would be clearer in my
> guidance.
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "tommcbrny" wrote:
>
> > Hi, I am using Excel 2007 and trying to apply conditional formatting as
> > follows:
> >
> > If number in column B is greater than number in column D, format text in
> > column A
> > If number in column B is less than number in column D, format text in column
> > C.
> >
> > So if B1 > C1, format A1, then if B2<C2, format D2, then if B3>C3, format
> > A3, and so on.
> >
> > I am able to format text in cell A1 if the number in B1 is greater than C1.
> > I also figured out how to apply this format to all cells in column A, but
> > only based on values in B1 & C1.
> >
> > Is there a way to specify the formual in conditional formatting so that it
> > compares row by row without entering a new conditional format rule for each
> > row?
> >
> > Thank you,
> > Tom
(Msg. 5) Posted: Thu Nov 05, 2009 8:17 am
Post subject: RE: Conditional Format Range of Cells [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Ah, never mind, I am able to specify the relative reference, that does the
trick. Thank you.
"Luke M" wrote:
> When you are writing the rule, make sure the row reference is relative ($B3)
> and not absolute ($B$3). This will allow the rule to adapt to each row you
> copy it to. I'm afraid I don't use 2007 myself, or I would be clearer in my
> guidance.
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "tommcbrny" wrote:
>
> > Hi, I am using Excel 2007 and trying to apply conditional formatting as
> > follows:
> >
> > If number in column B is greater than number in column D, format text in
> > column A
> > If number in column B is less than number in column D, format text in column
> > C.
> >
> > So if B1 > C1, format A1, then if B2<C2, format D2, then if B3>C3, format
> > A3, and so on.
> >
> > I am able to format text in cell A1 if the number in B1 is greater than C1.
> > I also figured out how to apply this format to all cells in column A, but
> > only based on values in B1 & C1.
> >
> > Is there a way to specify the formual in conditional formatting so that it
> > compares row by row without entering a new conditional format rule for each
> > row?
> >
> > Thank you,
> > Tom
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office