If cel in next colum same row = less color red

[Nelson]

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

 

[Jacob Skaria]

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

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK


If this post helps click Yes

 

[Nelson]

This wont work, I need to say that if I1>H1 turn red and if I2>H2, I3>H3, so
on and so on.

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

 

[Jacob Skaria]

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 Format>Conditional 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

 

[Gord Dibben]

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