If cel in next colum same row = less color red
 

Good day, I am not sure if conditional formatting will work with this but
here is what I am looking for

I have 2 columns H and I. H has previous years sales numbers and I has
current years.

I want to select all of column I and say if cell in H (same row) is less
than I turn I column red

Any suggestions

Thanks
--
Nelson

If cel in next colum same row = less color red
 

1. Select the cell/Range
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=I1<H1

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK


If this post helps click Yes
---------------
Jacob Skaria


"Nelson" wrote:

Good day, I am not sure if conditional formatting will work with this but
here is what I am looking for

I have 2 columns H and I. H has previous years sales numbers and I has
current years.

I want to select all of column I and say if cell in H (same row) is less
than I turn I column red

Any suggestions

Thanks
--
Nelson

If cel in next colum same row = less color red
 

This wont work, I need to say that if I1H1 turn red and if I2H2, I3H3, so
on and so on.

Can this be done without having to set a conditional format on each row?
--
Nelson


"Jacob Skaria" wrote:

1. Select the cell/Range
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=I1<H1

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK


If this post helps click Yes
---------------
Jacob Skaria


"Nelson" wrote:

Good day, I am not sure if conditional formatting will work with this but
here is what I am looking for

I have 2 columns H and I. H has previous years sales numbers and I has
current years.

I want to select all of column I and say if cell in H (same row) is less
than I turn I column red

Any suggestions

Thanks
--
Nelson

If cel in next colum same row = less color red
 

You dont need to set that in each row.

--Select Column I. The highlighted cell should be I1. (background would be
white)
--Now from menu FormatConditional Formatting enter the formula...
--Even if the formula refers to the first cell; conditional formatting is
applied to all cells in the selection.

Try and feedback

If this post helps click Yes
---------------
Jacob Skaria


"Nelson" wrote:

This wont work, I need to say that if I1H1 turn red and if I2H2, I3H3, so
on and so on.

Can this be done without having to set a conditional format on each row?
--
Nelson


"Jacob Skaria" wrote:

1. Select the cell/Range
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=I1<H1

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK


If this post helps click Yes
---------------
Jacob Skaria


"Nelson" wrote:

Good day, I am not sure if conditional formatting will work with this but
here is what I am looking for

I have 2 columns H and I. H has previous years sales numbers and I has
current years.

I want to select all of column I and say if cell in H (same row) is less
than I turn I column red

Any suggestions

Thanks
--
Nelson

If cel in next colum same row = less color red
 

Did you try before you said it won't work?

You need to have a look at the help files on "relative and absolute cell
references" and see how Excel will increment a cell address throughout a
selection of cells.

Just for practice........forget CF

Enter =A1 in B1

Drag/copy down to B10

Check each cell to see how the A1 reference increments.

Formulas in CF do the same thing.


Gord Dibben MS Excel MVP


On Thu, 17 Sep 2009 10:21:32 -0700, Nelson
wrote:

This wont work, I need to say that if I1H1 turn red and if I2H2, I3H3, so
on and so on.

Can this be done without having to set a conditional format on each row?